You don't. You said you had a lot of spaces in between. TRIM() will
remove all but one.

If you need to have at least one space, try

=TRIM(A1 & " " & B1)

In article ,
Metalteck wrote:

How do I get a space between the first name and last name using the trim
command?