merging 2 cells and adding a space.

  • Thread starter Thread starter paul
  • Start date Start date
P

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
 
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
 
Back
Top