Re: deleting hypen from zip+4

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


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:


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…> wrote in message
> 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.


In response to

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