Can I format zip code merge field to add hyphen if zip plus 4?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ShaniraW - 07 Mar 2006 18:10 GMT

We have several people who enter addresses, and some put only the five main
digits of the zip code, others put the zip +4 code and include a hyphen,
while the rest use the zip+4 format but don't add the hyphen. Is there a way
I can format the results of this field during the merge to add a hyphen where
needed, remove the hyphen if not needed, etc. In trying one way, it added a
hyphen to all results, including the 5 digit only code. On these, it also
added 4 zeros after the hyphen. Any thoughts on how to fix my problem and
avoid the added problem mentioned?

Reply to this Message

Doug Robbins - Word MVP - 07 Mar 2006 19:36 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> We have several people who enter addresses, and some put only the five
> main
[quoted text clipped - 8 lines]
> added 4 zeros after the hyphen. Any thoughts on how to fix my problem and
> avoid the added problem mentioned?

Reply to this Message