Code to differentiate between numbers and characters in a cell

Good afternoon,

I am trying to write a piece of code that looks at a list of post codes and uses the position of characters and numbers in order to identify whether they are UK based or not.

My rule for this code is that in all cases where the first and second characters are letters and the third character is a number then it will remove these cases from the spreadsheet, e.g. if a post code is RM12 6TU then it will be removed from the spreadsheet, but if it is N32 2BL then the post code will stay in the spreadsheet.

Is this something that is possible? And any ideas on how I would construct the syntax for this?

Thank you very much for your time on this.

Louise

That looks cool - will give it a try - thank you