How to stop Text-to-Columns splits as default

Question

I was copy-pasting some data from a PDF price book into Excel. I then then split the data into different columns along the $. However, when I then copy-pasted the next section of the PDF into Excel, it automatically split along the $. The problem is, I don't want this data to be split along that now.
How can I reset that so that Excel does not automatically recognize $ as a delimiter for all incoming data?

bkraines · Answer

Text To Columns remembers your last parse settings but you can only run it on a nonempty range. Follow these steps to reset the parse settings:

Enter foo into an unused cell, say Z1
With Z1 selected, click Text To Columns from the Data ribbon and choose Delimited
Uncheck each delimiter and click Finish

Your next paste won't automatically parse. Instead, you can choose Text To Columns and choose your own parse settings.

How to stop Text-to-Columns splits as default

One Answer

Add your own answers!

Ask a Question