Excel Text Functions

Combine, split, clean, and reformat text with CONCAT, TEXTJOIN, LEFT/RIGHT/MID, TRIM, and more.

10 guides in this collection

How to Combine Text with CONCAT and the & Operator in Excel

Learn how to join text from multiple cells using the & operator, CONCAT, and CONCATENATE to build full names, email addresses, and labels.

Learn how to use TEXTJOIN in Excel to combine text from multiple cells with custom delimiters for cleaner data and reports.

Learn how to use LEFT, RIGHT, and MID to pull specific characters from cells in Excel, with step-by-step examples.

Learn how to use LEN, TRIM, and CLEAN to find and fix hidden spaces and non-printable characters in Excel data.

Learn how to use TRIM, CLEAN, and SUBSTITUTE to fix messy text in Excel, with syntax, examples, and formulas you can combine.

Learn how to use PROPER, UPPER, and LOWER in Excel to quickly fix capitalization and keep your text consistent.

Learn how to use FIND and SEARCH to locate text within cells in Excel, with examples for splitting data and handling case sensitivity.

Learn how to use the TEXT function in Excel to format dates, numbers, and IDs as text with custom format codes.

Learn how to use Flash Fill in Excel to split, combine, and reformat data from a single example, without writing formulas.

Learn how to use wildcard characters (* and ?) in COUNTIF, SUMIF, VLOOKUP, and other Excel functions to match partial text.