Consolidating 2 fields into 1 ???

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

Joe Maha

How do you consolidate 2 Columns into 1 Column?

I have over 10,000 fields with a Zip Code in 1 field and
the 4 Digit extension in another. How do you combine them
so that they will look like (i.e.: 19124-1234)

Please Assist!
 
Hi
use
=A1 & "-" & B1
and copy this down for all rows. To do this you can simply double-click
on the lowe right corner of this formula cell
 
Back
Top