Re: deleting hypen from zip+4

Giganews Newsgroups
Subject: Re: deleting hypen from zip+4
Posted by:  Earl Kiosterud (nowhe…@verizon.net)
Date: Tue, 28 Oct 2003

Jonjon,

If they're numbers, you can remove the custom formatting (Format - Cells -
Number).  If they're text, put this in a helper column and copy down:

=SUBSTITUTE(A2,"-",)

You can now copy this column, and use Paste Special - Values to replace the
original zip codes, then do away with the helper column.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"jonjon" <anonymo…@discussions.microsoft.com> wrote in message
news:06e101c39dc6$9f1932a0$a40128…@phx.gbl...
> I'm trying to delete the hypen from the zip+4. Example:
> 90210-1234 into 902101234.
>
> I need to take out the hypen in order to mail merge the
> zipcode using a postnet font.
>
> Thank you.

Replies

In response to

deleting hypen from zip+4 posted by jonjon on Tue, 28 Oct 2003