What it does
Splitting columns separates combined text such as names, codes and addresses.
Syntax or pattern
Workflow steps vary by workbook✅
5 practical examples
1
Split by delimiter
Split full names by space.
Data → Text to Columns → DelimitedWorks best for consistent delimiters.
2
Split code by dash
Separate product prefix and number.
Data → Text to Columns → Delimited → DashUseful for product codes.
3
Use TEXTSPLIT
Split text with a formula.
=TEXTSPLIT(A2,"-")Dynamic formula alternative in newer Excel.
4
Extract before delimiter
Use LEFT and FIND.
=LEFT(A2,FIND("-",A2)-1)Works when you need formula control.
5
Extract after delimiter
Use MID and FIND.
=MID(A2,FIND("-",A2)+1,LEN(A2))Useful for helper columns.
Common mistakes to avoid
- Keep raw data separate from reports.
- Use clear table names and labels.
- Avoid over-formatting before the data structure is stable.
Related Excel examples
FAQ
Can this be combined with formulas?
Yes. Most Excel workflows work best when formulas, tables and formatting support each other.