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?
|