Not sure if you can help me but I have been trying to find the right formula to sort within a column of cells for words. Within the column are email addresses. My goal is to create a sort function that will sort (using key words) through a column of a few thousand records(job titles) so I can give them a value to sort them into categories.
Right now I have only been able to get this formula to work:
=FIND("assistant", A2)
And would have to go one word at a time.
My question is if I can create a formula to search the entire column to identify as many job titles as possible using a command that allows for multiple options within the Find function. In other words, is there a way to do =FIND("receptionist" OR "assistant" OR "sales" OR "etc", A2)
The OR part above is what I don't know how to create-any ideas?
Bookmarks