software

Hello, I have an excel file from a customer and I have to combine their first
and last name into 1 column. They have the first name in column A and the
last name in column B. I need to get these into 1 column so they can be pout
into the UPS System. Thanks in advance!!!!


You can insert a blank column to the left of Column A so your column A
will be blank: Then enter the following formula; =CONCATENATE(B1,quot;,
quot;,C1)
B1 is the First Cell
quot;, quot; is if you want anything to follow - in this case I have inserted a
quot;,quot; and hard space.
If you do not want the , and hard space - just delete it and leave the
comma which proceeds C1.
C1 is your second cell.
Then copy down.
Then copy all of Column A and then quot;PASTE - SPECIAL - Valuesquot; then you
can delete column Column B and C and your values will remain.
Work with a copy and not the original.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=511892Did this work for you? I can get A1 and B1 to combine into C1, but I can't
delete columns A and B without the data in Column C disappearing completely. When I try to copy Column C to another worksheet and start again with the
'good' information, all I get is #REF! in all the cells in the column. What
am I doing wrong? Thanks for any help you can give me...

quot;Slothquot; wrote:

gt; You can't automatically but you can use a helper colomn to combine the data.
gt; In C1 insert something like this...
gt; =A1amp;quot;_quot;amp;B1
gt; copy the formula down the list
gt; copy the colomn and paste special selecting values
gt; then delete the unwanted or/and old columns
gt;
gt; FYI:
gt; =A1amp;quot;_quot;amp;B1
gt; converts John Smith to John_Smith
gt; =A1amp;quot; quot;amp;B1
gt; converts John Smith to John_Smith
gt; =B1amp;quot;, quot;amp;A1
gt; converts John Smith to Smith, John
gt;
gt;
gt; quot;VPP Industriesquot; wrote:
gt;
gt; gt; Hello, I have an excel file from a customer and I have to combine their first
gt; gt; and last name into 1 column. They have the first name in column A and the
gt; gt; last name in column B. I need to get these into 1 column so they can be pout
gt; gt; into the UPS System. Thanks in advance!!!!

I guess that you didn't read the bit that said:
quot;copy the colomn and paste special selecting valuesquot; ?
--
David Biddulph

quot;JADavis126quot; gt; wrote in message
...
gt; Did this work for you? I can get A1 and B1 to combine into C1, but I
gt; can't
gt; delete columns A and B without the data in Column C disappearing
gt; completely.
gt; When I try to copy Column C to another worksheet and start again with the
gt; 'good' information, all I get is #REF! in all the cells in the column.
gt; What
gt; am I doing wrong? Thanks for any help you can give me...
gt;
gt; quot;Slothquot; wrote:
gt;
gt;gt; You can't automatically but you can use a helper colomn to combine the
gt;gt; data.
gt;gt; In C1 insert something like this...
gt;gt; =A1amp;quot;_quot;amp;B1
gt;gt; copy the formula down the list
gt;gt; copy the colomn and paste special selecting values
gt;gt; then delete the unwanted or/and old columns
gt;gt;
gt;gt; FYI:
gt;gt; =A1amp;quot;_quot;amp;B1
gt;gt; converts John Smith to John_Smith
gt;gt; =A1amp;quot; quot;amp;B1
gt;gt; converts John Smith to John_Smith
gt;gt; =B1amp;quot;, quot;amp;A1
gt;gt; converts John Smith to Smith, John
gt;gt;
gt;gt;
gt;gt; quot;VPP Industriesquot; wrote:
gt;gt;
gt;gt; gt; Hello, I have an excel file from a customer and I have to combine their
gt;gt; gt; first
gt;gt; gt; and last name into 1 column. They have the first name in column A and
gt;gt; gt; the
gt;gt; gt; last name in column B. I need to get these into 1 column so they can be
gt;gt; gt; pout
gt;gt; gt; into the UPS System. Thanks in advance!!!!
I followed these steps, but when I use the fill series command only the
second column reference adjusts. The first column stays B1 for all cells.
What am I doing wrong?

quot;wjohnsonquot; wrote:

gt;
gt; You can insert a blank column to the left of Column A so your column A
gt; will be blank: Then enter the following formula; =CONCATENATE(B1,quot;,
gt; quot;,C1)
gt; B1 is the First Cell
gt; quot;, quot; is if you want anything to follow - in this case I have inserted a
gt; quot;,quot; and hard space.
gt; If you do not want the , and hard space - just delete it and leave the
gt; comma which proceeds C1.
gt; C1 is your second cell.
gt; Then copy down.
gt; Then copy all of Column A and then quot;PASTE - SPECIAL - Valuesquot; then you
gt; can delete column Column B and C and your values will remain.
gt; Work with a copy and not the original.
gt;
gt;
gt; --
gt; wjohnson
gt; ------------------------------------------------------------------------
gt; wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
gt; View this thread: www.excelforum.com/showthread...hreadid=511892
gt;
gt;


Bierte;196603 Wrote:
gt; I followed these steps, but when I use the fill series command only the
gt; second column reference adjusts. The first column stays B1 for all
gt; cells.
gt; What am I doing wrong?
gt;
gt; quot;wjohnsonquot; wrote:
gt;
gt; gt;
gt; gt; You can insert a blank column to the left of Column A so your column
gt; A
gt; gt; will be blank: Then enter the following formula; =CONCATENATE(B1,quot;,
gt; gt; quot;,C1)
gt; gt; B1 is the First Cell
gt; gt; quot;, quot; is if you want anything to follow - in this case I have inserted
gt; a
gt; gt; quot;,quot; and hard space.
gt; gt; If you do not want the , and hard space - just delete it and leave
gt; the
gt; gt; comma which proceeds C1.
gt; gt; C1 is your second cell.
gt; gt; Then copy down.
gt; gt; Then copy all of Column A and then quot;PASTE - SPECIAL - Valuesquot; then
gt; you
gt; gt; can delete column Column B and C and your values will remain.
gt; gt; Work with a copy and not the original.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; wjohnson
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; wjohnson's Profile: 'Excel Help Forum - View Profile: wjohnson'
gt; (www.excelforum.com/member.php...oamp;userid=29640)
gt; gt; View this thread: 'Can I combine column A into Colum B? - Excel Help
gt; Forum' (www.excelforum.com/showthread...hreadid=511892)
gt; gt;
gt; gt;

When you have entered the formula, make sure the cell with the formula
is selected, then double-click the handle at the lower right corner of
the cell.--
Pecoflyer

Cheers -
*'Membership is free' (www.thecodecage.com)* amp; allows file
upload -gt;faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: www.thecodecage.com/forumz/member.php?userid=14
View this thread: www.thecodecage.com/forumz/sh...ad.php?t=54178how can i Combine Serial numbers Data Column A amp; B in column C ?

example:

A Column B Column C Column
20 25 21
21 26 22
22 27 23
23 28 24
24 29 25 26 27 28 29Where did 20 go?

Copy/paste then sort on column C only.Gord Dibben MS Excel MVP

On Thu, 14 Jan 2010 22:27:02 -0800, ahmed gt;
wrote:

gt;how can i Combine Serial numbers Data Column A amp; B in column C ?
gt;
gt;example:
gt;
gt;A Column B Column C Column
gt;20 25 21
gt;21 26 22
gt;22 27 23
gt;23 28 24
gt;24 29 25
gt; 26
gt; 27
gt; 28
gt; 29
gt;
gt;
gt;
gt;
gt;
gt;