Easy Tech TutsHow to Split a Cell Horizontally in Google Sheets Easily 2026
By Impran M N
Data like full names, addresses, or dates often arrive as one combined text string, making it hard to sort or analyze in Google Sheets. This guide covers two reliable ways to split that text horizontally across columns — the built-in Split Text to Columns menu option and the dynamic SPLIT formula — so your rows stay clean and usable.
01Prepare adjacent empty columns
Make sure there's enough empty space to the right of your data column so the split values don't overwrite anything important.
02Use Split Text to Columns
Select your data and choose the Split Text to Columns option from the Data menu.
03Choose the correct separator
Pick the right delimiter — like a comma or space — that matches how your text is structured.
04Try the SPLIT formula instead
For a more dynamic, formula-based approach, write a SPLIT function to extract data without altering the original cell.
05Apply the formula down the column
Copy the SPLIT formula down your entire data range to apply it consistently.
06Watch for overwritten cell warnings
If Sheets warns about overwriting adjacent data, clear the target cells first or adjust your column placement.
Frequently asked questions
What's the difference between Split Text to Columns and the SPLIT formula?
Split Text to Columns physically breaks the text into separate cells one time, while the SPLIT formula dynamically recalculates the split whenever the source data changes.
Can I split text by more than one type of separator?
Yes, you can choose custom separators, including combinations of commas, spaces, or other characters depending on your data format.
What happens if the split data overwrites existing rows?
Google Sheets will typically warn you before overwriting, so it's best to clear or set aside adjacent columns beforehand.
Can I split dates and times using this method?
Yes, custom dividers can be used to separate date and time fields that are combined in a single cell.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
