merging 2 cells and adding a space.
 

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

merging 2 cells and adding a space.
 

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

--
Rick (MVP - Excel)


"paul" wrote in message
...
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