I need to add a dash five characters from the first in a cell

A

Angela

I have zip codes in a field fields that I need to add a dash between the
first part of the zip and the second four numbers so the instead of looking
like "902101234", it looks like "90210-1234". How do I do this?
 
D

David Billigmeier

This looks like a zip code, is it? If so, you can just format it as such...
Format->Cells->'Number' Tab->Special->"Zip Code + 4"

Otherwise you can use this formula:
=CONCATENATE(LEFT(A1,5),"-",RIGHT(A1,4))

Change the A1 reference to match your data.
 
D

David Billigmeier

haha I just re-read your post and noticed you specified it was a zip code...
you can use the first part of my post to format it! :)
 
J

JE McGimpsey

If you just need it to display with the dash, choose the appropriate
format from the Format/Cells/Number/Special dialog.

If you actually need the - inserted, one way:

B1: =TEXT(A1,"00000-0000")
 
K

krasher

Thanks. This is exactly what I needed to do. The instructions were easy and
my envelopes mail merge correctly now.
Vivian
 
Top