software

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: www.excelforum.com/member.php...oamp;userid=30697
View this thread: www.excelforum.com/showthread...hreadid=503608
if you want to put the full name into C1 the formula is as follows:

=B1amp;quot;, quot;amp;A1

hope that helps--
superkopite
------------------------------------------------------------------------
superkopite's Profile: www.excelforum.com/member.php...oamp;userid=29496
View this thread: www.excelforum.com/showthread...hreadid=503608Use in column C ( or any un-used column) enter
=A1 amp; B1 and copy down. Then copy the new column and paste/special as value
back into column AIf you want to reverse the name order then use
=B1 amp; A1
If you want a space between the names then use
=A1 amp; quot; quot; amp; B1
--
Gary''s Studentquot;akrgovicquot; wrote:

gt;
gt; If I have two words in two cells (in A1 John, in B1 Smith) can I merge
gt; it in some way into one cell? I know COPY option but I need to move all
gt; words in B column into A column beside existing words. In A column I
gt; have second name and in B column first name.
gt; Thanks.
gt;
gt;
gt; --
gt; akrgovic
gt; ------------------------------------------------------------------------
gt; akrgovic's Profile: www.excelforum.com/member.php...oamp;userid=30697
gt; View this thread: www.excelforum.com/showthread...hreadid=503608
gt;
gt;


Thanks! Works perfectly.--
akrgovic
------------------------------------------------------------------------
akrgovic's Profile: www.excelforum.com/member.php...oamp;userid=30697
View this thread: www.excelforum.com/showthread...hreadid=503608