Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel is automatically doing "text to columns" upon paste text.
How do I stop Excel from automatically doing "text to columns" when I paste
text/numbers from a document? |
#2
|
|||
|
|||
You probably have a delimiter set for TEXT TO COLUMNS within the spreadsheet
you are editing. Before pasting the text/numbers from the document, do a TEXT TO COLUMNS parse on no data and deselect all of the delimiters that are set. Then paste in the data you want to paste. Come back if you have more questions. Barb Reinhardt "robert10000" wrote: How do I stop Excel from automatically doing "text to columns" when I paste text/numbers from a document? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel text to columns | Excel Discussion (Misc queries) | |||
Where is text to speech in excel 2003? | Excel Discussion (Misc queries) | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |