Can I combine column A into Colum B?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,",
",C1)
B1 is the First Cell
", " is if you want anything to follow - in this case I have inserted a
"," 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 "PASTE - SPECIAL - Values" then you
can delete column Column B and C and your values will remain.
Work with a copy and not the original.
 
Did 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...
 
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?
 
Using concatenate how can I combine three cell values in 3 different columns-
23, 20, 25 to look like 23(20-25) in one cell?
 
how can i Combine Serial numbers Data Column A & 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
29
 
Back
Top