TransWikia.com

How to stop Text-to-Columns splits as default

Super User Asked on December 18, 2021

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?

One 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:

  1. Enter foo into an unused cell, say Z1
  2. With Z1 selected, click Text To Columns from the Data ribbon and choose Delimited
  3. 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.

Answered by bkraines on December 18, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP