In column D use the formula
=A1&" "&B1&" "&C1
The " " would put in your spaces in between the names.
Then go to column D & do Edit Copy, move to column A & do
Edit Paste. Then you should be able to delete columns B,
C & D.
Hope that helps!
-----Original Message-----
I have first, middle, and last names in A, B, and C. I
want to merge
everything into A. Ho do I do that?
.
|