Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to columns - now paste does same
I sleceted some cells and did some text to column conversion with a
comma as teh delimiter. After doing this I had some data from another source that I pasted into another cell on this spreadsheet and the text to column function was invoked on this data. was there something I had to do to terminate the earlier text to column operation? John Keith |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to columns - now paste does same
Start the "Data/ Text to columns" dialogue again. Deselect the comma
delimiter. At this stage you can cancel, and hopefully the paste will then be OK. -- David Biddulph "John Keith" wrote in message ... I sleceted some cells and did some text to column conversion with a comma as teh delimiter. After doing this I had some data from another source that I pasted into another cell on this spreadsheet and the text to column function was invoked on this data. was there something I had to do to terminate the earlier text to column operation? John Keith |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to columns - now paste does same
On Wed, 12 Sep 2007 08:39:27 +0100, "David Biddulph" <groups [at]
biddulph.org.uk wrote: Start the "Data/ Text to columns" dialogue again. Deselect the comma delimiter. At this stage you can cancel, and hopefully the paste will then be OK. That sounded like a plausible solution, however my testing tonight did not support this suggestion. But thank you for looking. John Keith |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to columns - now paste does same
Try it again.
Put some test data into an empty cell Select that cell data|text to columns|delimited, but uncheck all the options and finish up. Clear that cell Then try pasting your data. John Keith wrote: On Wed, 12 Sep 2007 08:39:27 +0100, "David Biddulph" <groups [at] biddulph.org.uk wrote: Start the "Data/ Text to columns" dialogue again. Deselect the comma delimiter. At this stage you can cancel, and hopefully the paste will then be OK. That sounded like a plausible solution, however my testing tonight did not support this suggestion. But thank you for looking. John Keith -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to columns - now paste does same
On Wed, 12 Sep 2007 21:53:35 -0500, Dave Peterson
wrote: Try it again. Put some test data into an empty cell Select that cell data|text to columns|delimited, but uncheck all the options and finish up. Clear that cell Then try pasting your data. Dave, Your reply seems to confirm the suggestion from the first responent. After spending some more time with the sptreadsheet I can't even reproduce the original problem now. I'll tuck this info away for a future day if I see the issue again. Thanks for replying. John Keith |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
text to columns - now paste does same
As soon as you close excel and reopen, excel's options for data|text to columns
are changed back to the defaults. So your testing will have to start with a Data|Text to columns--to change the options away from the defaults. John Keith wrote: On Wed, 12 Sep 2007 21:53:35 -0500, Dave Peterson wrote: Try it again. Put some test data into an empty cell Select that cell data|text to columns|delimited, but uncheck all the options and finish up. Clear that cell Then try pasting your data. Dave, Your reply seems to confirm the suggestion from the first responent. After spending some more time with the sptreadsheet I can't even reproduce the original problem now. I'll tuck this info away for a future day if I see the issue again. Thanks for replying. John Keith -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how paste w/o put in columns? | Excel Discussion (Misc queries) | |||
How paste text from note pad to excel w/o using (Text to column) f | Excel Worksheet Functions | |||
Excel is automatically doing "text to columns" upon paste text. | Excel Discussion (Misc queries) | |||
Linking text columns with text and data columns | Excel Worksheet Functions |