Turn off text to columns
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. |
Turn off text to columns
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 |
Turn off text to columns
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 |
Turn off text to columns
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 |
Turn off text to columns
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 |
Turn off text to columns
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 |
All times are GMT +1. The time now is 07:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com