CONCATENATE formula

jkeeton · Apr 1, 2005

When using the CONCATENATE formula, how do I get a space between the 2 fields
in the result cell?

JulieD · Apr 1, 2005

Hi

=CONCATENATE(A1," ",B1)
or slightly less typing
=A1 & " " & B1