Thread: Extracting 1st 3-digits of postal code that begin with 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pcakes
 
Posts: n/a
Default Extracting 1st 3-digits of postal code that begin with 0
I have to extract the first 3-digits of a postal code, currently using:

=LEFT(A1,3)

However, this will not pull correctly if the postal code begins with 0.

Example: 04587 will pull 458 instead of 045.

Any suggestions?
Reply With QuoteReply With Quote