Text to columns

N

nc

Why is it when I use Data, Text to colulmns, the next I time I try to paste
data on another already opened sheet/workbook, the data especially the amount
is split between two columns?
 
D

Dave Peterson

Excel likes to help by remembering the last settings you did in your Data|text
to columns. It can be very nice sometimes--and very irritating other times.

You can close excel and reopen it to "reset" that memory (ughhh!).

Or you can pick an unused cell
put some junk characters in it (asdf)
and then do a data|text to columns
choose delimited and uncheck all the options.
Then clean up that cell.

If you find that you have to do this lots of times, you may want to record a
macro while you do that manually.

And then rerun that macro whenever you need to reset it.
 
Top