Hi All,
This should be a simple one?
I'm currently using - =IF(D3="EXC","",LEFT(D3,2))
Column D being a list of postcodes.
works fine for most Postcodes, but the single letter ones - i.e Sheffield/S and Birmingham/B it add the number to it, obviously as i'm asking for the 2 characters in the...