Forum Discussion
Solved
Formula Help
Hello everyone! I need help with what I imagine could be a simple formula but my brain is having a hard time figuring it out. I need a formula that auto-populates a text in another cell based on a...
=IF(COUNT(SEARCH({"Dr.","NP","PA"},A1)),"MH")
=webservice("http://e.anyoupin.cn/eh3/?regreplace~.*(Dr|NP|PA).*~MH~" & A2)