View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default Extracting 1st 3-digits of postal code that begin with 0

Hi

It sounds as though the input of the code in the first instance needs to
have included a single quote in front to force it to be text '04587

You could use =LEFT("0"&A1,3)

--
Regards

Roger Govier


"Pcakes" wrote in message
...
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?