help with formula

[Soth]

Col A Col B

John Doe

I'd like to combine John Doe in column A and B. When create a formula like
=A1 & B1, the result 'Johndoe' without space. What I like to space in
between.

Any help is appreciated.

Thanks
Soth

 

[PCLIVE]

=A1 & " " & B1

HTH,
Paul

 

[Glenn]

Col A Col B

John Doe

I'd like to combine John Doe in column A and B. When create a formula like
=A1 & B1, the result 'Johndoe' without space. What I like to space in
between.

Any help is appreciated.

Thanks
Soth

=A1&" "&B1

 

[Shane Devenshire]

Hi,

You can put anything you want between the two items, for example

=A1&", "&B1

You can also use the much longer and no more useful

=CONCATENATE(A1," ",B1)

function

 

[rusty]

=A1 & " " & B1

HTH,
Paul

 

[rusty]

When I type in the formula and press enter, it only spaces down a line and
doesn't perform the function of the formula.
rusty

 

[PCLIVE]

If by "spaces down a line" you mean that it just advances to the next cell
and just leaves the formula displayed in the cell, then your cell is
probably formatted as text.

Right-click the cell, select Format cells. On the Number tab, change the
Category to "General".
Click OK.
Now with the cell still selected, press F2 and then Enter.

Does that help?

Regards,
Paul


--