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 |
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 |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com