Where is Text to Columns in Excel?

Text to Columns is on the Data tab. Select the column first, then choose Data > Text to Columns.

Should I use Text to Columns or TEXTSPLIT?

Use Text to Columns for a one-time cleanup. Use TEXTSPLIT when you need a dynamic formula that updates automatically.

Yes. In the final step, choose the correct date order such as MDY, DMY, or YMD.

No. It is a one-time transformation. Use formulas or Power Query for automatic updates.

Tutorials - 2026-05-12

Learn Text to Columns in Excel for splitting names, emails, CSV values, fixed-width codes, dates, and imported data cleanup.

Text to Columns splits one column into multiple columns. It is one of the fastest tools for cleaning imported data. Use it for: First and last names Comma-separated values Product codes Email usernames and domains Dates imported as text

Select the column, then use: Data -> Text to Columns -> Delimited Choose the delimiter, such as comma, space, semicolon, or tab.

Choose Fixed width when each part starts at a consistent position. This works well for structured codes, exports, and legacy system reports. Preview the break lines before finishing.

Text to Columns can also convert dates stored as text. Choose the right date format in the final step, such as MDY or DMY.

Source pattern Setting Comma-separated values Delimited -> Comma Names separated by spaces Delimited -> Space System codes with fixed positions Fixed width Dates imported as text Date format in final step

Text to Columns overwrites destination cells if you are not careful. Before finishing: Choose a blank destination range Preview the split columns Confirm the delimiter Check date order such as MDY vs DMY Keep a copy of the original imported column

Use Split Text in Excel, TEXTSPLIT, TRIM, and Power Query when cleanup needs to repeat.

Where is Text to Columns in Excel? Text to Columns is on the Data tab. Select the column first, then choose Data > Text to Columns.
Should I use Text to Columns or TEXTSPLIT? Use Text to Columns for a one-time cleanup. Use TEXTSPLIT when you need a dynamic formula that updates automatically.
Can Text to Columns fix dates stored as text? Yes. In the final step, choose the correct date order such as MDY, DMY, or YMD.
Does Text to Columns update automatically? No. It is a one-time transformation. Use formulas or Power Query for automatic updates.