How to merge two columns of data

D

David in VB

Hi all, I'm sure there is a simple function I'm overlooking:

Here is my desired result: I have about 400 rows of data. In column G, I
want to add "for the purposes of" in front of every name that is already in
column G. So, I inserted a column F with the words "for the purposes of"
and then tried to merge it with G, but it just erases the names in G. Any
thoughts?
 
D

David in VB

I did see another post that helps, but I'm still not sure where to go.

Another question asked how to merge columns A, B and C together. A, B and C
contain the first, middle and last name and the person wants to merge the
columns together for one name. That's what I'm trying to do. Any help?
 
D

David Biddulph

In a spare column, use the formula ="for the purposes of "&G2 and copy down.
If you want to use that to replace the existing contents of column G, copy
your new column, select column G, Edit/ Paste Special/ values, then you can
delete your extra column.
 
D

David in VB

David,

Fantastic! I really appreciate it. How about this one: I have three
columns A, B and C which contain First Name, Middle Initial, Last Name. How
do I merge all of those into one column?

Thanks!
 
B

Bob I

Same method, use A2&B2&C2
David,

Fantastic! I really appreciate it. How about this one: I have three
columns A, B and C which contain First Name, Middle Initial, Last Name. How
do I merge all of those into one column?

Thanks!

:
Click to expand...
 
Top