How do I separate out the first 5 digits of the post code if I have addresses like these all in one cell? I can't figure it out using Left, Right or Mid functions.
ALPHARETTA GA 30023-2818 ---> needs to be 30023
ALBION CA 95410-0760 ----> needs to be 95410
BOCA RATON FL 33431-4227 ---> needs to be 33431
ALPHARETTA GA 30023-2818 ---> needs to be 30023
ALBION CA 95410-0760 ----> needs to be 95410
BOCA RATON FL 33431-4227 ---> needs to be 33431