Combining Column Data

E

Elaina

I need to combine the data in two columns so that the data
in Column A will appear in teh same cell as the data in
Column B. I do not want to merge the cells.
It needs to change from:
Column A Column B
123 JONES

And appear as
Column A
123 Jones

I have a list of over 2000 rows..I really don't want to
manually type in thedata! Thanks!

-E
 
G

Govind

Hi Elaina,

Not possible without using a helper column. In column c enter the
formula C1 = A1&B1.

And then copy the column C and paste it over column A as values.(Use
copy and then paste special - values)

Regards

Govind
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
How to center adjust text above and image in a two column document. 1
MS Project Center-Autolink column fields 0
Need Help with a VBA subroutine 0
Cell data entering slow! 0
Two columns followed by single page-width column on same page 0
Merging from an Excel file with graphics 1
Format column widths from one table to a separate table on same page 1

Top