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?



"David in VB" wrote:

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?

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 Biddulph

"David in VB" wrote in message
...
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?

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!

"David Biddulph" wrote:

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 Biddulph

"David in VB" wrote in message
...
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?

Same method, use A2&B2&C2

David in VB wrote:

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!

"David Biddulph" wrote:


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 Biddulph

"David in VB" wrote in message
...

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?