This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I wonder if what you're doing in Excel is actually doing what you want...
If you have ZIPs that are longer than 5 characters, why not simply use ToNumber(Left([A1],5))?
If you use the Excel-style expression above, you would get a 6 digit code if your A1 has 10 characters (e.g. 01234-1234 would return 01234-). If you use the expression above and your A1 value has 7 characters, a Left([A1],5) would give you the same result as the Excel-style expression.
Also, what about A1 values less than 5 characters?