merging 2 cells and adding a space.

[paul]

I want to merge 2 cells into 1 and add a space.

for example I have this:
A1 = Tim
B1 = Smith
I want to make either A1 = Tim Smith or C1 = Tim Smith

How would I do this? I have tried text to column with not much luck

 

[Rick Rothstein]

You can't do it in A1 without using VB... you can't have a formula and a
text constant in the same cell. You can do it in C1 though...

=A1&" "&B1