Concatenate first, middle and last names

L

liliamma

I have first, middle and last names in 3 different columns. How do I
concatenate them in another column so I have spaces between them but when
there's no middle name it doesn't show extra spaces in the result?
 

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

TRIM Help ! 8
complicated text to column 4
Formula for stripping text 5
Parse Name field with multiple characthers 1
Lookup Help Please?! 2
Formula To Split Name 5
Concatenate error 3
Separating Full Names into First Middle and Last 1

Top