Turn off text to columns

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

 

[Dave Peterson]

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 Peterson]

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]

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.

 

[Hamilton]

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.

 

[T. Valko]

I hate when that happens!

http://spreadsheetpage.com/index.php/tip/clearing_the_text_to_columns_parameters/

 

[T. Valko]

I hate when that happens!

http://spreadsheetpage.com/index.php/tip/clearing_the_text_to_columns_parameters/

 

[Hamilton]

Thanks again. Is this problem fixed in Office 2007??

 

[Hamilton]

Thanks again. Is this problem fixed in Office 2007??

 

[Dave Peterson]

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

 

[Dave Peterson]

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