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...)
So I've seen this solution in two places, but when I try 'text to columns' on an empty cell, I get this error message: "No data was selected to parse"
- Ok so I have to put a space in that cell first to do that. Ok - thank you!
MysidEmq you can do it on any cell with a something in it. Because you are trying to clear all settings from the text-to-columns and you don't need to click on "finish", it won't matter where you do it.
After you just paste your data and it will not show you multiple columns.
