Google Sheets: Extracting Zip codes with in multiple forms.

Originally Posted by Ghozi Alkatiri

sory my be this one
=INT(LEFT(REPLACE(MID(A1,5,LEN(A1)),1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},MID(A1,5,LEN(A1))&1/17))-1,""),5))

giving me an error, doesnt like that the - is included as an integer