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

Wrapping and Anchors 0
Grouping Names in Mail Merge 0
Formating bolded text exclusively. 0
Mail Merge Help 1
complicated text to column 4
Combining three files when middle file has sections with endnotes 2
Formula To Split Name 5
Formula for stripping text 5

Top