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" wrote:

=A1 & " " & B1

HTH,
Paul

--

"Soth" wrote in message
...

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