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

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

Guest

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?
 
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.
 
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! :-)
 
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")
 
Thanks. This is exactly what I needed to do. The instructions were easy and
my envelopes mail merge correctly now.
Vivian
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting a cell - remove a dash 5
deleting from within a cell 3
formatted to place dashes within numbers formatted as text 1
Adding a dash 3
inserting cell data into a hyperlink 4
Displaying zeros in cells 2
Pulling partial information from a cell 2
adding a dash 1

Back
Top