How to Consolidate Columns?

  • Thread starter Thread starter Joe Maha
  • Start date Start date
J

Joe Maha

How do you Consolidate Columns in Excel? I have a
database of 11,000 names. I have the Zip code in the
address broken down into seperate columns with the Zip
code in one column and the Zip code + 4 digit in another
column. *I need them to be consolidated into 1 column!

Please Help!
 
Joe said:
How do you Consolidate Columns in Excel? I have a
database of 11,000 names. I have the Zip code in the
address broken down into seperate columns with the Zip
code in one column and the Zip code + 4 digit in another
column. *I need them to be consolidated into 1 column!

Please Help!
Click to expand...
An illustration would help. Do you mean

94024 940245901 ?

Alan Beban
 
Your wording is not too clear and ambiguous.

See if this helps.

A1 = Help
B1 = Me
This formula in C1:
=A1&B1
Would return "HelpMe"
Adjust the formula to
=A1&" "&B1
Would return "Help Me"

SO, if you had:

A1 = 123 Any Street AnyCity, AnyState
B1 = 90210
C1 = 8411

In D1 enter this:

=A1&" "&B1&"-"&C1
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

How do you Consolidate Columns in Excel? I have a
database of 11,000 names. I have the Zip code in the
address broken down into seperate columns with the Zip
code in one column and the Zip code + 4 digit in another
column. *I need them to be consolidated into 1 column!

Please Help!
 
Back
Top