How do I stop automatic conversion of text-to-columns in excel?
When I've used copy and paste of text into a workbook followed by
Data-Text-to-columns once, excel seems to assume that every future paste of text also requires a text-to column conversion even when I don't want that to happen. How do I stop this occurring. thanks john bell |
How do I stop automatic conversion of text-to-columns in excel?
You can close and reopen excel (yech!)
Or you can put some dummy data into a cell data|text to columns delimited uncheck all the options and finish up. Then clean up that dummy data in that cell. wraith_oz wrote: When I've used copy and paste of text into a workbook followed by Data-Text-to-columns once, excel seems to assume that every future paste of text also requires a text-to column conversion even when I don't want that to happen. How do I stop this occurring. thanks john bell -- Dave Peterson |
How do I stop automatic conversion of text-to-columns in excel
Many thanks Dave. That behaviour has been really annoying me.
jb "Dave Peterson" wrote: You can close and reopen excel (yech!) snip wraith_oz wrote: When I've used copy and paste of text into a workbook followed by snip -- Dave Peterson |
All times are GMT +1. The time now is 11:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com