ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pasting from clipboard-how to control text-to-columns delimiting (https://www.excelbanter.com/excel-discussion-misc-queries/30851-pasting-clipboard-how-control-text-columns-delimiting.html)

stebro

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

Jim Rech

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