Concatenate function

[mthompson93]

Hi,

Is there a way I can use the Concatenate function but put a few spaces between the two sets of content I want to join together?

[NBVC]

Yes...

e.g.

=Concatenate(A1," ",B1)

or

=A1&" "&B1

[Ron Coderre]

Actually, using the CONCATENATE function would be a long way of doing this:

With
A1: FIRST
A2: LAST

A3: =A1&" "&A2

In that example, A3 returns: FIRST LAST

Is that something you can work with?

[mthompson93]

Thanks again!