I have a list of records each with a postcode that takes either of the two formats:
SA1 6HU
N4 3HF
I also have a list of postcodes that show only the first part of postcodes
SA1
SA2
N3
N4
What formula would look up "SA1 6HU" and return SA1? while being also able to look up "N4 3HF" and return N4?
Bookmarks