ExcelBanter - Concatenate first, middle and last names

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Concatenate first, middle and last names (https://www.excelbanter.com/excel-discussion-misc-queries/243560-concatenate-first-middle-last-names.html)

liliamma

Concatenate first, middle and last names

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?

Per Jessen[_2_]

Concatenate first, middle and last names

Hi

How about this:

=TRIM(A1 & " " & B1 & " " & C1)

Regards,
Per

On 24 Sep., 04:15, liliamma
wrote:
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?

All times are GMT +1. The time now is 03:13 PM.