Forum Discussion
Potentially complex formula
Hello. This is my first post on here so bear with me. I have a workbook with full name cells that have first and last name data that are formatted as follows: "Mickey De La Ratones (nickname)" wi...
A2 hold Mickey De La Ratones (nickname)
B2
=WEBSERVICE("http://e.anyoupin.cn/eh3/?preg_match~^\S+\s([^(]+)\s\(~" & A2 & "~1")
B2
=WEBSERVICE("http://e.anyoupin.cn/eh3/?preg_match~^\S+\s([^(]+)\s\(~" & A2 & "~1")