Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn Off automatic parsing of data in Excel
I use Excel 2003
If I open up excel and then paste in a column of text, it gets pasted in literally as text. I then use the "Text to Column" feature to parse the data. All this is fine. However, the next time I paste in a column of text, Excel will automatically parse the data as I paste it in. Does anyone know how to turn this off? It seems to be an attribute the is preserved for the current excel session. If I close out of excel and reopen it, then the automatic parsing is not enabled. I want to be able to turn of the automatic parsing within an excel session. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn Off automatic parsing of data in Excel
Try this:
select any nonblank cell and do a fake data parcing - go through the same steps just when you need to check/uncheck the parcing delimiter (coma, semicolon, tab or whatever) uncheck those boxes Finish. Next time you paste the parcing won't be in effect. On 17 July, 16:08, rcl2884 wrote: I use Excel 2003 If I open up excel and then paste in a column of text, it gets pasted in literally as text. I then use the "Text to Column" feature to parse the data. *All this is fine. However, the next time I paste in a column of text, Excel will automatically parse the data as I paste it in. Does anyone know how to turn this off? It seems to be an attribute the is preserved for the current excel session. If I close out of excel and reopen it, then the automatic parsing is not enabled. I want to be able to turn of the automatic parsing within an excel session. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I turn off the automatic ordering of the data in Pivot Cha | Charts and Charting in Excel | |||
How do I turn off automatic fill coloring in excel | Excel Discussion (Misc queries) | |||
How do I turn off the automatic hyperlink function in Excel? | Excel Worksheet Functions | |||
How do you turn off automatic "save a copy" in Excel | Excel Discussion (Misc queries) | |||
how do you turn off automatic hyperlink in excel 2003 | Excel Discussion (Misc queries) |