Merging three cells into one
 

I have four cells I want to merge into one cell.
I have used the "=A1 & " " & B1 & " " & C1 & " " & D1
to combine them into one cell - but what do I use to tell it
to not put a space if there is no middle initial or no suffix? Thanks

A1 A2 A3 A4
John D. Ameen
Kenneth E. Amos Jr.
Brett Anderson
Gregory T. Anderson

Merging three cells into one
 

=A1&IF(B1="",""," "&B1)&C1&IF(D1="",""," "&D1)

Hope this helps.
--
John C


"Randi" wrote:

I have four cells I want to merge into one cell.
I have used the "=A1 & " " & B1 & " " & C1 & " " & D1
to combine them into one cell - but what do I use to tell it
to not put a space if there is no middle initial or no suffix? Thanks

A1 A2 A3 A4
John D. Ameen
Kenneth E. Amos Jr.
Brett Anderson
Gregory T. Anderson

Merging three cells into one
 

or, if you like....
=TRIM(A1&" "&B1&" "&C1&" "&D1)
--
John C


"Randi" wrote:

I have four cells I want to merge into one cell.
I have used the "=A1 & " " & B1 & " " & C1 & " " & D1
to combine them into one cell - but what do I use to tell it
to not put a space if there is no middle initial or no suffix? Thanks

A1 A2 A3 A4
John D. Ameen
Kenneth E. Amos Jr.
Brett Anderson
Gregory T. Anderson

Merging three cells into one
 

Actually, this one should have been:
=A1&IF(B1="",""," "&B1)&" "&C1&IF(D1="",""," "&D1)
--
John C


"John C" wrote:

=A1&IF(B1="",""," "&B1)&C1&IF(D1="",""," "&D1)

Hope this helps.
--
John C


"Randi" wrote:

I have four cells I want to merge into one cell.
I have used the "=A1 & " " & B1 & " " & C1 & " " & D1
to combine them into one cell - but what do I use to tell it
to not put a space if there is no middle initial or no suffix? Thanks

A1 A2 A3 A4
John D. Ameen
Kenneth E. Amos Jr.
Brett Anderson
Gregory T. Anderson