Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pasting from clipboard-how to control text-to-columns delimiting
I have Excel 2003. I often copy text from other applications and simply want
to paste into excel - not going thru wizards or text-to-columns options. Sometimes when I paste it parses the data (for example, on commas, etc) among several columns and sometimes it doesn't. I can't figure out how or what is controlling this. At the moment I'm trying to change it back to no-parse but can't figure out how to do it. Up until now when I pasted it would put everything in the row in one cell - then the next row in the cell below, etc -- just the way I want it. Any suggestions??? -Thanks, Steve |
#2
|
|||
|
|||
This may help:
http://support.microsoft.com/default...b;en-us;127132 -- Jim "stebro" wrote in message ... |I have Excel 2003. I often copy text from other applications and simply want | to paste into excel - not going thru wizards or text-to-columns options. | Sometimes when I paste it parses the data (for example, on commas, etc) among | several columns and sometimes it doesn't. I can't figure out how or what is | controlling this. | | At the moment I'm trying to change it back to no-parse but can't figure out | how to do it. Up until now when I pasted it would put everything in the row | in one cell - then the next row in the cell below, etc -- just the way I want | it. | | Any suggestions??? -Thanks, | Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pasting data from a website changes text to date | Excel Discussion (Misc queries) | |||
problem when pasting text | Excel Discussion (Misc queries) | |||
Excel clipboard should allow pasting of formulae not just values | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |