Sheet1, column A contains the following data:
BOFL
BOF Locations
Building our Future Locations
These are all variations of the same same value, just written in slightly different ways.
In Sheet 2, Column A, I have listed all of the variations (I may need to add more variations in future). I...