I bet MS sees this as a feature, not a problem.
There are lots of times when I'm copying different data with the same layout
(same parsing rules) where this comes in handy.
Hamilton wrote:
Thanks again. Is this problem fixed in Office 2007??
"T. Valko" wrote:
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
--
Dave Peterson