Forum Discussion

excel_learner's avatar
excel_learner
Brass Contributor
Jul 08, 2022

Using Left Function with If statement

I am using the Left function to get first two letters of a Postal Code, however in some of the postal codes the first two characters contains a number. How can I ignore the number in the postal codes which have a number in the first two characters.

For example below W8, W1, N1. The numbers would need to be removed leaving just W, W and N.

Is there a formula using the LEFT function with an IF statement to do this ?

SW3  5UZSW
SW3  5UZSW
LU1  1TULU
W8   4RNW8
UB8  2DWUB
W11  4RSW1
N10  3TEN1
HA0  4JUHA
NW10 2QDNW

Resources