Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mareku
 
Posts: n/a
Default Copy/Paste of separated columns

If you select column A and D in Excel and copy them into the Clipboard
you will see that there are actualy four columns A, B, C, D in the
Clipboard. (I use Clipbrd.exe to view the clipboard).

Does anyone knows workarround for it? I want to paste the columns into
my own program, but not all of them, just the selected. I have noticed
that even Word Paste command works this way. Yet maybe someone has
already solved this problem.

Thanks
Marek
  #2   Report Post  
FuadsCurse
 
Posts: n/a
Default

Could you paste column A and D into another spreadsheet (which will eliminate
the blank columns) and then copy and paste to your program from that? It
seems crude to have to take that extra step, but just a thought.

Brett

"mareku" wrote:

If you select column A and D in Excel and copy them into the Clipboard
you will see that there are actualy four columns A, B, C, D in the
Clipboard. (I use Clipbrd.exe to view the clipboard).

Does anyone knows workarround for it? I want to paste the columns into
my own program, but not all of them, just the selected. I have noticed
that even Word Paste command works this way. Yet maybe someone has
already solved this problem.

Thanks
Marek

  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

If I hid columns B:C, I could copy A thru D and paste into notepad and only
columns A and D showed up.

Maybe it'll work with your other program, too.

mareku wrote:

If you select column A and D in Excel and copy them into the Clipboard
you will see that there are actualy four columns A, B, C, D in the
Clipboard. (I use Clipbrd.exe to view the clipboard).

Does anyone knows workarround for it? I want to paste the columns into
my own program, but not all of them, just the selected. I have noticed
that even Word Paste command works this way. Yet maybe someone has
already solved this problem.

Thanks
Marek


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Columns in Excel will not allow user to click in them Kim Excel Discussion (Misc queries) 1 December 28th 04 06:37 PM
Counting the Contents of Two Columns Molochi Excel Discussion (Misc queries) 6 December 22nd 04 08:13 PM
Pivot Table Creating New Columns that Subtract Two Existing Columns den4673 Excel Discussion (Misc queries) 3 December 17th 04 01:31 PM
interchange columns with rows Herman Excel Discussion (Misc queries) 2 December 8th 04 05:40 PM
How can I find the common names in two columns of names? hako Excel Discussion (Misc queries) 2 December 8th 04 01:59 AM


All times are GMT +1. The time now is 11:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"