Text to Columns

N

nc

Whenever I used text to column, the next time I copy, its uses the same
format as the last text to column when I paste.

How can I reset "Text to columns" without the need to close the Excel?
 
J

Joel

Either go to a new worksheet or clear the area on the current worksheet. I
ofter select the entire worksheet by press the gray cell between Row 1 and
column A and the press DELETE. You can also go to a new area on the
worksheet where previous data was not imported. Excel rrecognizes that you
are import to the same area as a previous Text to Column (or imported data)
and using the old format to do the operation. You simply need to delete the
previous data.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting Text data using the Data - Subtotal feature 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
my zero keeps dropping even though formatted as text 3
Text to columns 2
Split column contents (de-concantenate) 7
Turn off text to columns 10
Text to Columns 1
Text to Columns Error 1

Top