| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Postcode Area extract first alpha letters
Hi,
I have a list of postcodes and would like to have only the first letters, whether this is 2 or 1 letter. I have been able to extract the beginning of a postcode with =LEFT(A1,FIND(" ",A1)-1) but now want to split it further and just have the letters not the numbers. Eg: "B1" return "B" "SW12" return "SW" "M23" return "M" "NN9" return "NN" etc. is there something that extracts alpha characters? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract alpha from a cell | Excel Discussion (Misc queries) | |||
| Extract alpha from a cell | Excel Discussion (Misc queries) | |||
| Extract alpha from a cell | Excel Discussion (Misc queries) | |||
| Extract Numbers from Alpha-Numeric String | Excel Worksheet Functions | |||
| Converting postcode to sales area | Excel Discussion (Misc queries) | |||
Threaded Mode
