PC Review


Reply
Thread Tools Rate Thread

How to Combine or Merge Columns?

 
 
Shani
Guest
Posts: n/a
 
      24th May 2006
I want to add everything that is in column B into Column A. How can i
do this effieciently?

 
Reply With Quote
 
 
 
 
davegb
Guest
Posts: n/a
 
      24th May 2006

Shani wrote:
> I want to add everything that is in column B into Column A. How can i
> do this effieciently?


Select all of column B, do an "Edit, Copy". The select the same rows in
column A and do an "Edit, Paste Special, Add".

This question should probably be posted in the regular Excel forum,
since no programming is required.

Hope this helps.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine multiple columns into two long columns, Repeating rows in first column anasab@gmail.com Microsoft Excel Misc 2 31st Jul 2006 09:45 PM
Combine multiple columns into two long columns, Repeating rows in first column anasab@gmail.com Microsoft Excel Misc 0 31st Jul 2006 05:07 PM
merge or combine columns Lee Beck Microsoft Excel Misc 5 22nd Jul 2004 01:44 PM
How to merge rows and columns into one cell without using Merge and Center Icon? valerie Microsoft Excel Discussion 2 19th Oct 2003 07:45 PM
How to merge columns and rows into one cell, besides using the Merge and Center icon? valerie Microsoft Excel Misc 1 17th Oct 2003 05:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:27 PM.