Subsection 3.2
Text to Columns vs SPLIT
Reading
Sheets gives you two ways to split a concatenated cell. Choose based on whether the source data will keep changing.
Text to Columns vs =SPLIT()
| Data › Split text to columns | =SPLIT(A1, ",") | |
|---|---|---|
| Type | Menu wizard. One-shot. | Formula. Lives in the cell. |
| When source changes | You have to rerun it. | It updates automatically. |
| Where the output lands | Overwrites adjacent columns. | Spills across cells to the right. |
| Best for | One-time cleanup before you start working with the file. | Live workbooks that other people keep editing. |
| Excel equivalent | Data › Text to Columns. | TEXTSPLIT in Excel 365. |
The rule of thumb
If the file will not change again, use Text to Columns and move on. If the file is shared and people are still adding rows, use =SPLIT() so the cleanup follows the new data automatically.
Action: Mark this page complete when you have finished the activity above.