merge two fields with a hypen between fields

  • Thread starter Thread starter Vivian
  • Start date Start date
V

Vivian

I have one field that has the city, state, zip.(this is a
merge of other fields) The second field has the +4
numbers of the zip. I want to merge these two with a
hyphen between the zip and the +4 numbers.
so it will say
city, state, zip-xxxx. I don't know how to make a
hyphen between the two fields when they merge.
I am using Office Beta 2003. How do you do this?
 
Let's assume your city, state, zip is in cell A1; and the
4 digit zip code is in cell B1.

In cell C1 key in the following formula:

=A1 & "-" & B1

HTH
 
Another option:

If your zipcodes are really numeric, you may have to format them nicely. One
way is like this:

=TEXT(A1,"00000")&"-"&TEXT(B1,"0000")

Or you could even keep them as numbers, then apply
Format|Cells|Number Tab|Special|Zip+4
Use this as your formula to combine:
=A1*10000+B1
 
Thank you all. I knew it had to be simple. It was
definitely beyond me without all your help.
 
Back
Top