Formula hub · Updated May 13, 2026

Text Cleanup

Clean names, IDs, emails, imported data, extra spaces, and inconsistent text.

Guides in this category

Text Cleanup Formulas

Clean imported spreadsheet text with TRIM, CLEAN, SUBSTITUTE, LEFT, RIGHT, and TEXTSPLIT.

Remove Extra Spaces in Excel and Google Sheets

Remove leading, trailing, repeated, and invisible spaces from spreadsheet text.

Split Full Name into First and Last Name

Split names in Excel or Google Sheets with TEXTSPLIT, SPLIT, LEFT, RIGHT, and TEXTAFTER.

TEXTJOIN Examples

Use TEXTJOIN to combine names, tags, IDs, or values with a delimiter.

Extract Domain from Email Address

Extract the domain name after the @ symbol from an email address in Excel or Google Sheets.

Extract Text Between Two Characters

Extract text between parentheses, brackets, dashes, or other delimiters.

Merge Two Columns in Excel or Google Sheets

Combine first name and last name, city and state, or other columns with a delimiter.

How to choose a formula

Start from the spreadsheet task, then choose the simplest formula that gives a maintainable answer. A report that someone else must update next month often needs clarity more than cleverness.