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