Concatenate first, middle and last names

[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?

 

[Per Jessen]

Hi

How about this:

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

Regards,
Per