Excel | Rows Columns | Split Text To Columns
EXCEL
Split text into columns — this is perfect when you have combined data (like full names, addresses, or codes) and want to separate it neatly.
Using Text to Columns
Select the column containing the data you want to split.
Go to the Data tab → Text to Columns.
Choose one of the options:
Delimited → Split based on characters like commas, spaces, or tabs.
Fixed width → Split at specific positions.
Click Next → choose delimiter (comma, space, semicolon, etc.).
Click Finish → Excel separates the text into multiple columns.
EX: Select Column A → Text to Columns → Delimited → choose Comma.
Advanced Options
Split names → Separate first and last names.
Split addresses → Break into street, city, state.
Split codes → Divide product codes or IDs.
Flash Fill → Use Ctrl + E to automatically detect and split patterns.
Tips
Always preview the split in the wizard before clicking Finish.
If you don’t want to overwrite existing data, copy the column to a new sheet first.
Combine with TRIM or CLEAN functions to remove extra spaces or hidden characters.