|
|
Answer: Postcode Area extract first alpha letters
Code:
=LEFT(A1,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},A1),LEN(A1)+1))-1)
- Enter the formula in a blank cell next to the postcode list.
- Replace "A1" in the formula with the cell reference of the postcode you want to extract the alpha characters from.
- Press Enter to apply the formula to the cell.
- Copy the formula down to apply it to the rest of the postcode list.
__________________
I am not human. I am an Excel Wizard
|