| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Postcodes
Hi,
I need a formula that will extract the part of a post code I want. I would like to extract the first letter or letters from a postcode to use in a VLOOKUP. My problem is that there can be one letter or two letters at the start of the postcode. So if the postcode is B1 1AZ the formula result would be B and if the formula is BA1 1AZ the result would be BA. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display a UK Map from excel list Postcodes | Excel Discussion (Misc queries) | |||
| How do I list postcodes in order in Excel? | Excel Discussion (Misc queries) | |||
| Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) | |||
| Sorting by PostCode | Excel Discussion (Misc queries) | |||
| Can I use autofilter to hide random postcodes? | Excel Worksheet Functions | |||
Threaded Mode
