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.


--
akrgovic
------------------------------------------------------------------------
akrgovic's Profile: http://www.excelforum.com/member.php...o&userid=30697
View this thread: http://www.excelforum.com/showthread...hreadid=503608

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

=B1&", "&A1

hope that helps


--
superkopite
------------------------------------------------------------------------
superkopite's Profile: http://www.excelforum.com/member.php...o&userid=29496
View this thread: http://www.excelforum.com/showthread...hreadid=503608

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
--
Gary''s Student


"akrgovic" wrote:


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.


--
akrgovic
------------------------------------------------------------------------
akrgovic's Profile: http://www.excelforum.com/member.php...o&userid=30697
View this thread: http://www.excelforum.com/showthread...hreadid=503608

Thanks! Works perfectly.


--
akrgovic
------------------------------------------------------------------------
akrgovic's Profile: http://www.excelforum.com/member.php...o&userid=30697
View this thread: http://www.excelforum.com/showthread...hreadid=503608