Two cells into one

A

akrgovic

If I have two words in two cells (in A1 John, in B1 Smith) can I merge
it in some way into one cell? I know COPY option but I need to move all
words in B column into A column beside existing words. In A column I
have second name and in B column first name.
Thanks.
 
S

superkopite

if you want to put the full name into C1 the formula is as follows:

=B1&", "&A1

hope that helps
 
G

Gary''s Student

Use in column C ( or any un-used column) enter
=A1 & B1 and copy down. Then copy the new column and paste/special as value
back into column A


If you want to reverse the name order then use
=B1 & A1
If you want a space between the names then use
=A1 & " " & B1
 
Top