Turn off text to columns
Dave,
Thank you very much. My parts list is full of hyphens, it was taking 6 key
strokes per move to overcome the Microsoft idea of helping.
"Dave Peterson" wrote:
You can close excel and reopen it.
Or you can do a dummy text to columns.
Find an empty cell
Put some junk in it (like: asdf)
Then do data|text to columns
Chose delimited by
But uncheck all the options
finish up the wizard
Clear that cell.
Hamilton wrote:
I used text to columns in Excel delimited with hypens. I open a new copy of
Excel and now everything that I try to paste with a hypen is split across
columns!! There must be a way to stop this.
--
Dave Peterson
|