Home > Formulas > Text > Topics

Excel Text Functions Guide

Debra Dalgleish - Contextures

A short guide to the Excel text functions, including TEXTJOIN, TEXTSPLIT, SEARCH, REPLACE, and many more.

first and last names reversed

Introduction: Excel Text Functions

These Text functions can be used to clean up data, extract information, or create custom labels.

Newer text functions, like TEXTJOIN, TEXTSPLIT, and REGEXTEST, make it easy to manipulate text strings, compared to the complex formulas we used to build!

Split Names

Quickly reverse first and last names in Excel. Or, split first and last names into separate cells. Use built-in Excel tools, or a simple formula, with the Excel MID function.

This video shows the steps to reverse first and last names with an Excel formula, and there are written steps beon the Excel Split Names page.

Combine Text from Multiple Cells

In this short video, I show how to combine cells in Excel, with text and number formatting in the result. There are written steps, and an Excel file, on the Combine Text page.

More Text Function Pages

  • Split Address -- How to split address in Excel. Formula to separate street, city, state, zip into columns. Quick split address Flash Fill shortcut. Video, Excel files. Details on the Split Address in Excel page.
  • TEXTSPLIT -- Split address or other text strings with Excel TEXTSPLIT function. Formula examples, practice file. Like Text to Columns feature, but with formulas. Details on the Excel TEXTSPLIT Function Examples page.
  • TEXTJOIN -- Combine text and numbers from multiple cells with Excel TEXTJOIN function. 7 examples, basic to advanced. Videos, written steps, workbooks. Excel 365. Details on the Excel TEXTJOIN Examples page.
  • CODE and CHAR -- How to use Microsoft Excel CODE function and CHAR function. Identify characters, insert special characters such as line breaks. Troubleshoot formula errors. Details on the Excel CODE and CHAR Function Examples page.
  • Text String Limits - How to avoid Excel formula text string limits warning messages. Details on the Formula Text String Limits page.
  • HTML and IFRAME -- How to create HTML and IFRAME code in Excel with formulas. Get the free workbook to see how it works. Details on the How to Create HTML Code and IFRAME Code in Excel page.
  • REPT -- Excel REPT function examples show in-cell bar chart, lookup last text entry, and more, with videos, written steps, and sample files for free download. Details on the Excel REPT Function Examples page.
  • Address -- Excel ADDRESS function examples - get column letter, cell with highest value, info from cell at row and column number location. Details on the Excel ADDRESS Function Examples page.
  • SUBSTITUTE or REPLACE -- Change text with Excel SUBSTITUTE and REPLACE functions. Which function to use? Remove old characters, add new text. Examples, videos, practice files. Details on the Fix Text Excel SUBSTITUTE and REPLACE Functions page.
  • SEARCH -- Easy Excel SEARCH function examples show how to check for characters in a text string and return its position number. Video, written steps, free workbook. Details on the Excel SEARCH Function Examples page.
  • Formula Text -- How to show a cell formula in another cell with Excel FORMULATEXT function. Troubleshoot worksheet formula problems. Details on the Excel FORMULATEXT Function page.
  • Remove Spaces -- How to remove spaces in Excel using TRIM, SUBSTITUTE, find and replace, macros. Videos, written steps, sample file. Avoid problems with sort, filter, lookup. Details on the Remove Spaces in Excel-Formula page.
  • EXACT -- Use Excel EXACT function to compare text strings for exact match, even upper lower case. Check passwords, find match in list, more examples. Video, workbook. Details on the Compare Cells with EXACT Function page.
  • Text Case -- How to change text case in Excel with Proper, Lower, Upper function. Examples and video.. Details on the Change Text Case With Excel Functions page.

More Functions

CHOOSE

LOOKUP

Engineering Functions

Lookup - 2 Criteria

HYPERLINK

INDIRECT

 

 

 

 

Last updated: May 30, 2026 3:29 PM