Forum Discussion
Solved
Stop automatic text-to-columns formatting
This morning I was pasting text into excel and using Text-to-Columns to parse it. Later, in a different file, I was pasting other text that I did not want parsed into different columns. But excel is a...
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...)
Your solution started to work(!thanks) but I no longer can remove unwanted delimiting bars. As soon as I select 'space' as a delimiter it separates first and last names into separate columns.
It doesn't have to be space, you can set up whatever delimiter you want, just set it to something that isn't going to come up in your data. "|" is popular, or "\" or "%".