| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can someone help me put psuedo code into actual excel macro?? | Excel Discussion (Misc queries) | |||
| Lost my Paste | Excel Discussion (Misc queries) | |||
| Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
| Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
| Formula for Extracting Alphabetic Part of a Product Code | Excel Worksheet Functions | |||
Threaded Mode
