Hello excelforum,
I am learning excel on my own(mostly from here). I have tried doing a search on the question but have not found anything so far/may be looking wrongly.
I have written out a formula
Is there any way i can say combine all my wildcards into a list and use it in the formula without having to type it out?
I want the formula to produce an error if two or more wildcards are found in the same phrase, if not, return a keyword to be used later.
The problem is that I have a large list of words such that if the phrase contains these words then an error is produced.
I have attached a sample workbook.
Thank you very much!
Jason
Bookmarks