Forum Discussion
Stop automatic text-to-columns formatting
Sometimes, Excel is too clever for its own good.
Select an empty cell.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next >.
Clear the check boxes of all delimiters.
Click Finish.
The problem should be gone (until the next time...)
Sometimes, Excel is too clever for its own good.
Select an empty cell.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click Next >.
Clear the check boxes of all delimiters.
Click Finish.
The problem should be gone (until the next time...)
- Jaqi HeglandCopper ContributorThank you, I've needed this for ages!
- timlonggrCopper Contributor
Is there any way to turn it off for good? Or will I need to do this every time I've used Text to Columns?
Excel will remember the settings during a session, but when you start Excel, there shouldn't be presets.
- Jeff_StubingCopper Contributor
HansVogelaar Thanks so much for your answer! This has been a frustration for me for years! FYI, it would not let me even open the Text to Columns dialog with a blank cell selected, but it worked fine with a populated cell selected. Thanks so much!