Excel Formulas - Convert Category
Stop struggling with complex spreadsheets. Learn how to quickly convert Excel formulas into values, text, or different cell references with our easy-to-follow guide. Master your data today!
Excel Formulas to Convert and Extract Numbers From Text
Learn the best Excel formulas to extract numbers from text strings or easily convert text-formatted numbers into actual numeric values.
Excel Formulas to Convert Between Celsius and Fahrenheit
Learn how to easily convert Celsius to Fahrenheit in Excel using the built-in CONVERT function or simple math formulas with this quick guide.
Excel Formulas to Convert Decimals to Percentages and Vice Versa
Learn how to easily convert decimals to percentages in Excel using formulas and formatting to keep your exact decimal places intact.
How to Convert Military Time to Standard Time in Excel
Learn how to easily convert military time (24-hour format) to standard AM/PM time in Excel using simple formulas and cell formatting.
Excel Formula to Convert Inches to Centimeters
Easily convert inches to centimeters in Excel using the CONVERT function. Get the exact formula and step-by-step examples here!
How to Convert Decimals to Fractions in Excel Using Formulas
Learn how to quickly convert decimals to fractions in Excel using the TEXT formula and simple cell formatting with this easy step-by-step guide.
Excel Formulas to Convert UTC to Local Time
Learn how to easily convert UTC to local time in Excel using a simple formula to adjust for time zone offsets.
Excel Formulas to Convert Standard Dates to Unix Timestamps
Easily convert standard dates to Unix timestamps (and vice versa) in Excel with these simple formulas and step-by-step examples.
Excel Formulas to Convert IP Addresses to Binary Code
Convert IP addresses to binary code in Excel instantly. Learn the exact formulas to translate IPv4 octets into 32-bit binary format step-by-step.
Excel Formulas to Convert Full Name to Last Name First
Easily convert full names to "Last Name, First Name" format in Excel using simple formulas. Clean up your spreadsheets and contact lists instantly!
Excel Formulas to Convert Dates to Days of the Week
Learn how to use the Excel TEXT formula to easily convert any date into the day of the week (e.g., Monday or Mon) with this quick, step-by-step guide.
Excel Formulas to Extract Domain Names From Email Addresses
Learn how to easily extract domain names from email addresses in Excel using simple formulas like TEXTAFTER, MID, and FIND.
Excel Formula to Convert Latitude and Longitude to Decimal Degrees
Easily convert latitude and longitude from Degrees Minutes Seconds (DMS) to Decimal Degrees with this quick and simple Excel formula guide.
Converting HTML Entities to Plain Text Using Excel Formulas
Easily convert HTML entities to plain text in Excel. Learn the best formulas and methods to decode characters like `&` and `"` instantly.
Excel Formulas for Converting Numbers to Spelled-Out Words
Easily convert numbers to words in Excel using formulas and the SpellNumber VBA code-perfect for automating invoices, check amounts, and financial reports.
How to Convert Julian Dates to Standard Dates in Excel
Learn how to easily convert Julian dates to standard calendar dates in Excel with these simple, step-by-step formulas.
How to Build a Dynamic Currency Converter in Excel Using Real-Time Exchange Rates
Learn how to easily convert currency in Excel using dynamic, real-time exchange rates with this simple step-by-step formula guide.
Excel Formulas to Convert Feet and Inches to Decimal Feet
Learn how to easily convert feet and inches to decimal feet in Excel with these simple, step-by-step formulas.
Excel Formulas to Convert Megabytes to Gigabytes (MB to GB)
Learn how to easily convert Megabytes (MB) to Gigabytes (GB) in Excel using a simple division formula or the built-in CONVERT function.
Excel Formulas to Convert 12-Hour Time to 24-Hour Format
Learn how to quickly convert 12-hour time (AM/PM) to 24-hour format in Excel using simple formulas and easy cell formatting tricks.
Excel Formulas to Convert Text to Numbers: A Complete Guide
Easily convert text to numbers in Excel using the VALUE formula and other quick methods to fix your formatted data and restore calculations.
How to Convert Numbers to Text in Excel Using Formulas
Learn how to quickly convert numbers to text in Excel using the TEXT function and other simple formulas to preserve leading zeros and formatting.
How to Convert Date to Text in Excel Using the TEXT Function
Learn how to use the Excel TEXT function to convert dates to text format quickly with step-by-step formulas and custom formatting examples.
Excel Formulas to Convert Text to Valid Dates
Learn how to quickly convert text into valid Excel dates using simple formulas like DATEVALUE, Text to Columns, and formatting tricks.
How to Convert Uppercase to Title Case in Excel Using the PROPER Function
Easily convert uppercase text to title case in Excel using the PROPER function. Learn the quick formula to clean up your spreadsheet capitalization instantly.
How to Convert Fahrenheit to Celsius in Excel
Learn how to easily convert Fahrenheit to Celsius in Excel using the built-in CONVERT function or a simple mathematical formula.
How to Convert Celsius to Fahrenheit in Excel
Learn how to convert Celsius to Fahrenheit in Excel quickly using the CONVERT function or a simple mathematical formula.
How to Convert Unix Timestamp to GMT Date in Excel
Easily convert Unix timestamps to GMT/UTC dates in Excel with this simple, step-by-step formula to translate epoch time instantly.
How to Convert Military Time to Standard Time in Excel
Learn how to easily convert military time (24-hour) to standard time (12-hour AM/PM) in Excel using simple formulas and custom cell formatting.
How to Convert Roman Numerals to Arabic Numbers in Excel
Learn how to easily convert Roman numerals to Arabic numbers in Excel using the ARABIC function with this quick, step-by-step guide.