I'm looking for formula which could search for various characters in multiple cells. This is my table example:
A 1 Oikes - Simon 2 Ksenia & Igor 3 Dan + Bea ...
And I want to search for "-","&","+" characters. I thought this formula could work but it doesnt:
=SEARCH("-";SEARCH("&";A2;1);1)
Is Search within Search even possible? If not, what formula should I use? Thank you.
Another option,
=-LOOKUP(1,-FIND({"&","-"},A1))
1.4m articles
1.4m replys
5 comments
56.9k users