I hate when that happens!

http://spreadsheetpage.com/index.php...ns_parameters/

--
Biff
Microsoft Excel MVP


"Hamilton" wrote in message
...
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