Google Sheets / 6 min read
Google Sheets Text Formula Examples
Use text formulas in Google Sheets for cleanup, joining values, extracting parts of strings, and normalizing pasted data.
Google Sheets text formulas help clean messy imports, combine fields, and extract useful parts of a string. The most practical starting set is TRIM, CLEAN, SPLIT, LEFT, RIGHT, MID, and CONCATENATE or TEXTJOIN.
Check this first
- Test with a visibly messy sample value first.
- Use TRIM before comparing imported text values.
- Use SPLIT only when the delimiter is truly consistent.
- Keep the original raw column until the cleaned result is verified.
Working examples
Remove extra spaces from imported text
=TRIM(A2)Split full name into first and last name by space
=SPLIT(A2, " ")Why text formulas matter
A large share of spreadsheet cleanup work is not math. It is text repair. People copy names, IDs, product labels, URLs, and exported notes into Sheets, then need to standardize or extract part of that content quickly.
That makes text formula pages strong SEO assets because they map directly to everyday office tasks.
Best beginner formula set
You do not need every text function to solve real problems. A small core set handles most cleanup jobs: TRIM for spaces, CLEAN for non-printing characters, SPLIT for delimiters, and LEFT or RIGHT for extracting a fixed pattern.
- TRIM for extra spaces.
- CLEAN for hidden import noise.
- SPLIT for delimiter-based data.
- LEFT, RIGHT, MID for substring extraction.
Keep the raw source until you trust the output
A good spreadsheet cleanup workflow keeps raw data untouched in one column and puts cleaned data in another. That makes it easier to compare results and reverse mistakes later.