Forum Discussion
Filter using text
I have a list of postal codes (image below), from which I wish to filter those that begin with 3 specific letters. For that I have another list of 200 "3 specific letters" beginnings that are valid. ...
mohsinrabbas You didn't mention which you are working with, so I'm giving you a solution that works on all.
Use VLOOKUP to find the first three characters from all the postal codes in the list of "deliverable codes", as demonstrated in the picture below. #N/A means that the code is not deliverable.