deleting hypen from zip+4

  • Thread starter Thread starter jonjon
  • Start date Start date
J

jonjon

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.
 
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.
 
Hi Earl, thanks for your help.
The Substitute formula worked like a charm. I was easily
able to strip the hypen off of the zip+4. Perhaps you can
help me one more time. I forgot to mention that I need to
enter a backslash (/) in the front and back of the zip+4.
I.E. 98020-1234 would than be/980201234/.

Thanks again.
 
anon,

If you've already stripped the hyphen, use:

="/" & A2 & "/"

To do it all at once:
= "/" & SUBSTITUTE(A2,"-",) & "/"
Click to expand...

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

Hi Earl, thanks for your help.
The Substitute formula worked like a charm. I was easily
able to strip the hypen off of the zip+4. Perhaps you can
help me one more time. I forgot to mention that I need to
enter a backslash (/) in the front and back of the zip+4.
I.E. 98020-1234 would than be/980201234/.

Thanks again.
Click to expand...
 
Earl, thank you once again.
You have been a great help with my problems. Once again,
it worked. This will help greatly with my mail mergeing
and barcoding a Postnet font for Office Publisher.
 
Back
Top