Google Sheets Split Text

Google Sheets can split text into separate columns with either the Split text to columns menu or the SPLIT function. Use it when one field contains multiple pieces of information that need to be filtered, sorted, matched, or summarized separately.

Common examples include full names, location codes, campaign tags, invoice labels, and exported descriptions.

Use Split text to columns

Step 1. Select the cells that contain combined text.

Step 2. Choose Data -> Split text to columns.

Step 3. Pick the separator, such as comma, space, semicolon, or custom.

This is fastest for one-time cleanup. For example, a contact export might have Jordan Lee, Retail, Referral in one cell. Splitting by comma creates separate fields for name, segment, and source.

That structure is more useful in a CRM lead tracker because source and segment can be filtered independently.

Use the SPLIT function

For a formula-based approach, use SPLIT.

If A2 contains Retail,Referral,High Priority, the formula spills each part into separate cells.

Use formulas when the split needs to update as source values change.

Clean spaces after splitting

Delimited text often includes spaces after commas. Wrap the result in TRIM when needed:

For a single row, that removes leading and trailing spaces from each split value.

When splitting text helps

The Griddy way

Text splitting is easy when every row follows the same pattern. Real exports rarely do.

"Split this imported description into vendor, category, project code, and notes, then flag rows that do not match the pattern"

Griddy can create the cleaned fields and identify exceptions before they break filters or reports.