=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