I have first, middle, and last name in different columns. How do I merge
these three into one column?

Try...

=A1&" "&B1&" "&C1 for the format John T. Smith

OR

=C1&", "&A1&" "&B1 for the format Smith, John T.

Hope this helps!

In article ,
"w8ting4hlp" wrote:

I have first, middle, and last name in different columns. How do I merge
these three into one column?

Domenic,

That looks like exactly what I need to do. However, I'm not sure what to do
with the solution formula you posted. Do I place =A1&" "&B1&" "&C1 in any
cell and hit enter? Or, do I place it in that bar above the table where the
cell information appears?

"Domenic" wrote:

Try...

=A1&" "&B1&" "&C1 for the format John T. Smith

OR

=C1&", "&A1&" "&B1 for the format Smith, John T.

Hope this helps!

In article ,
"w8ting4hlp" wrote:

I have first, middle, and last name in different columns. How do I merge
these three into one column?

If your first name, middle name and last name are in A1, B1, and C1, then you
can put that formula in D1.

You can actually put the formula in any cell you want--just not one of the cells
with the names.

David in VB wrote:

Domenic,

That looks like exactly what I need to do. However, I'm not sure what to do
with the solution formula you posted. Do I place =A1&" "&B1&" "&C1 in any
cell and hit enter? Or, do I place it in that bar above the table where the
cell information appears?

"Domenic" wrote:

Try...

=A1&" "&B1&" "&C1 for the format John T. Smith

OR

=C1&", "&A1&" "&B1 for the format Smith, John T.

Hope this helps!

In article ,
"w8ting4hlp" wrote:

I have first, middle, and last name in different columns. How do I merge
these three into one column?


--

Dave Peterson

Can this formula be used with a whole range? Like A1:A25?

"Dave Peterson" wrote:

If your first name, middle name and last name are in A1, B1, and C1, then you
can put that formula in D1.

You can actually put the formula in any cell you want--just not one of the cells
with the names.

David in VB wrote:

Domenic,

That looks like exactly what I need to do. However, I'm not sure what to do
with the solution formula you posted. Do I place =A1&" "&B1&" "&C1 in any
cell and hit enter? Or, do I place it in that bar above the table where the
cell information appears?

"Domenic" wrote:

Try...

=A1&" "&B1&" "&C1 for the format John T. Smith

OR

=C1&", "&A1&" "&B1 for the format Smith, John T.

Hope this helps!

In article ,
"w8ting4hlp" wrote:

I have first, middle, and last name in different columns. How do I merge
these three into one column?


--

Dave Peterson

Maybe you're asking if you can use the same kind of formula in each cell in
A1:A25???

If that's the question, then the answer is yes.

JaredC wrote:

Can this formula be used with a whole range? Like A1:A25?

"Dave Peterson" wrote:

If your first name, middle name and last name are in A1, B1, and C1, then you
can put that formula in D1.

You can actually put the formula in any cell you want--just not one of the cells
with the names.

David in VB wrote:

Domenic,

That looks like exactly what I need to do. However, I'm not sure what to do
with the solution formula you posted. Do I place =A1&" "&B1&" "&C1 in any
cell and hit enter? Or, do I place it in that bar above the table where the
cell information appears?

"Domenic" wrote:

Try...

=A1&" "&B1&" "&C1 for the format John T. Smith

OR

=C1&", "&A1&" "&B1 for the format Smith, John T.

Hope this helps!

In article ,
"w8ting4hlp" wrote:

I have first, middle, and last name in different columns. How do I merge
these three into one column?


--

Dave Peterson


--

Dave Peterson