Turn off text to columns

  • Thread starter Thread starter Hamilton
  • Start date Start date
H

Hamilton

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.
 
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.
 
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.
 
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,

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.
 
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.

Thanks again. Is this problem fixed in Office 2007??
Click to expand...
 
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.

Thanks again. Is this problem fixed in Office 2007??
Click to expand...
 
Back
Top