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.

Check the delimiter and edge cases

Splitting is only safe when the delimiter is reliable. Inspect a sample of the source values for commas inside quoted addresses, multiple spaces, missing separators, and values that already contain the delimiter. Leave the original column intact until you verify the output. After splitting, check the maximum number of resulting columns, trim accidental spaces, and decide how blank pieces should be handled. For recurring imports, document the delimiter and use a stable helper range rather than manually overwriting the source data each time.

If the source contains quoted CSV values or inconsistent delimiters, clean the import before splitting. Do not split a column that is also used as a stable lookup key until you have decided which new field should be the key.

Sources

• Google Docs Editors Help: SPLIT function
• Google Docs Editors Help: Google Sheets function list