Merging three cells into one

R

Randi

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
 
J

John C

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Text From Cells 3
Merging multiple columns into one column (dynamically) 1
Conditional Concatenate? 2
Combining multiple cells into one 3
Combine Text Cells 3
Different cells that need to sum in one 4
Display only unique values in CONCATENATE formula 4
Cobining various numbers of cells without using the & or concatena 2

Top