Can you Split by "-"?

Yes, Alex

Alex
Thanks Alex, I got it working.

Glad you got it working, Werner. Yep, Split is a good approach when the hyphen is consistently present.

If it isn't, you can check the length first. A ZIP code that's exactly 9 characters can be split, one that's exactly 5 should be left alone, and anything else means you've got some weird data to investigate. It gets trickier if you also need to handle postal codes from other countries, such as Canada or the UK.