Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
moving text from a word document to excel | New Users to Excel | |||
Error message when using Excel to open text file | Excel Discussion (Misc queries) | |||
Automatic data conversion in Excel | Excel Discussion (Misc queries) | |||
How do I stop automatic page breaks in excel | Excel Worksheet Functions |