Text Formulas
Learn Excel text formulas such as LEFT, RIGHT, MID, LEN, TRIM, and SUBSTITUTE with interactive lessons and exercises.
Char, Unichar & Code Formulas
Learn how to use CHAR, UNICHAR, and CODE in Excel to insert in-cell line breaks, generate checkmarks and bullets, and inspect character numbers.
Concat & Textjoin String Formulas
Learn how to combine text in Excel using CONCAT and TEXTJOIN. Discover how to add custom delimiters, ignore blank cells, and build clean mailing labels.
Exact Case-sensitive Text Formula
Learn how to compare text in Excel with the EXACT formula. Discover how to detect password case differences, match inventory codes, and spot tiny typos.
Find & Search String Lookup Formulas
Learn how to locate text positions in Excel using FIND and SEARCH. Discover case-sensitivity differences, wildcards, and dynamic text slicing.
Number Formatting With Text Formula
Learn how to convert numbers into formatted text strings in Excel with TEXT. Format currencies, leading zeros, and dynamic date strings for executive reports.
Substitute & Replace String Formulas
Learn how to swap text in Excel using SUBSTITUTE and REPLACE. Discover how to replace words by name, mask phone numbers, and overwrite coordinates.
Text String Formatting Formula
Learn how to convert numbers into formatted text strings in Excel with TEXT. Preserve currency symbols, dates, and percentages in dynamic sentence labels.
Upper, Lower & Proper Text Casing
Learn how to change letter casing in Excel using UPPER, LOWER, and PROPER. Clean messy name capitalization, fix email formats, and standardize lists.
Left, Right & Mid String Slicing
Learn how to slice text strings in Excel using LEFT, RIGHT, and MID. Extract product SKU codes, area codes, and middle sequence IDs easily.
Len & Rept Text Length Formulas
Learn how to use LEN and REPT in Excel to audit SMS character limits, repeat text symbols, and build visual in-cell star ratings without charts.
Trim & Clean Data Cleansing Formulas
Learn how to use TRIM and CLEAN in Excel to fix extra spaces, remove invisible non-printable characters, and prevent VLOOKUP #N/A lookup errors.
Value, T & N Data Type Coercion
Learn how to convert text numbers in Excel using VALUE, T, and N. Fix numbers formatted as text, convert booleans, and clean calculation data.
Learning how to work with text is essential for cleaning and organizing messy data. This path focuses on splitting, cleaning, and combining text to build reusable data cleaning steps and automated reports.
You will learn how to combine text values, split strings, and convert formats — making it easier to handle imported data and real-world spreadsheet problems.