How to merge two columns of data

  • Thread starter Thread starter David in VB
  • Start date Start date
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?
 
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?
 
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.
 
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!
 
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...
 
Back
Top