Desk Clarity

Everyday document & browser help

Split Comma-and-Space Lists in Sheets Without Splitting Every Space

By ON Lab · Sources checked November 6, 2026

To split text on the exact sequence comma plus space in Google Sheets, use =SPLIT(A1, ", ", FALSE) in a separate output area. The third argument matters: by default, SPLIT treats each character in its delimiter separately. Setting it to FALSE makes comma-plus-space one delimiter, so a space inside a multiword name is not itself a split point.

Choose the result you need

A Sheets reader describes a country list separated by commas and spaces and an unavailable Split text to columns menu. The current official function reference supports a formula route for separating that kind of list. It does not identify why that reader's menu was disabled. This guide therefore explains the text transformation, without claiming to repair the menu state.

The result is a series of cells across one row. If you need one item per row, a full CSV import, or records duplicated for every item, those are different transformations. Decide the intended shape before changing the original data.

1. Preserve the original and inspect its separator

Keep the original list in one cell and put the formula somewhere else with room for the output. Do this in a working copy of an important sheet. Read the actual separators: a comma followed by one space is different from a comma alone, two spaces, or a line break.

For an illustrative source in A1, use Albania, United Kingdom, South Africa. Each country is one item. Splitting at every space would incorrectly break the last two names. This example explains the documented function arguments; it is not a claim that we opened the reader's spreadsheet.

2. Use an exact multicharacter delimiter

=SPLIT(A1, ", ", FALSE)

Here A1 supplies the text, the quoted comma and following space supply the delimiter, and FALSE turns off character-by-character splitting. The expected fragments for the example are Albania, United Kingdom and South Africa, in separate cells on the same row.

Compare that with =SPLIT(A1, ", "). Google's default for split_by_each is TRUE. With that default, either the comma or the space can divide the text. The two formulas can look nearly identical while defining different boundaries.

If your list uses commas without spaces, choose =SPLIT(A1, ",", FALSE) instead. If the list mixes separator styles, do not silently assume they all match the two-character sequence. Inspect and standardize a checking copy according to the actual data rule.

3. Decide whether empty fields matter

The optional fourth argument is remove_empty_text. Its default is TRUE, which treats consecutive delimiters as one. For records where an empty position has meaning, use FALSE and inspect the resulting empty positions.

=SPLIT(A1, ",", FALSE, FALSE)

For example, red,,blue split on commas with empty text preserved should keep a blank position between red and blue. With the default empty-text behavior, that blank position is removed. A visually neat output can therefore lose information if empty fields are significant.

The comma-plus-space delimiter has its own exact matching rule. Two adjacent commas are not two adjacent occurrences of comma-plus-space. Choose the formula from the source structure, rather than copying a four-argument version without reading it.

4. Verify every item before using the result

  1. Compare the number of output fragments with the intended number of items.
  2. Check multiword items, punctuation and the first and last item.
  3. Check whether blank fields should exist and whether they were kept.
  4. Confirm that the original cell still contains the complete original list.
  5. Review later rows individually when their separators differ.

SPLIT removes the delimiter characters from its result. If a comma is part of an item's real text, it cannot also be treated blindly as a separator. A formula that splits every comma is not a general parser for quoted CSV fields containing commas.

When the menu or formula still does not fit

Google's computer instructions also document selecting the intended cells, choosing Data → Split text to columns, and using the Separator menu. That route and the formula route are alternatives for suitable data; neither proves the cause of an unavailable menu in a particular file.

If the output shape or item boundaries are wrong, return to the unchanged source and revise the delimiter rule. Do not overwrite the source with an unverified split. For a parsing error, report the exact formula, source text and environment using a nonsensitive sample; do not share a private editable spreadsheet merely to demonstrate the problem.

Completion means the intended items occupy the intended cells without lost words or meaningful empty positions. This guide does not provide a verified fix for disabled controls, mobile-specific behavior or every CSV import problem.

Sources