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

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.


--
Regards,
Dave


"Angela" wrote:

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?

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! :-)

--
Regards,
Dave


"Angela" wrote:

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?

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")

In article ,
Angela wrote:

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?

Ha Ha is right but that's Great! I really appreciate it!

"David Billigmeier" wrote:

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! :-)

--
Regards,
Dave


"Angela" wrote:

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?

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

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

"Angela" wrote:

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?