Pulling 5-digit zip codes from fields

[lthomas]

I have a database I'm pulling address information from that puts the city, state and zip all in one field. So the field looks like this:

LAS VEGAS, NV 89131-1234

I just need to pull the 5-digit zip codes from this field. Any hints on the simplest way to accomplish this?

Thanks in advance!

Les :^)

[MarvinP]

Hi Les,

If your example is in A1 then try this formula

Please Login or Register  to view this content.

You will need a comma followed by a space and a 2 letter state abreviation for it to work.

hope this helps.