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...
Mickey De La Ratones (nickname)
What is your expected result from above string?
The regular expression may accomplish it.
What is your expected result from above string?
The regular expression may accomplish it.
- A2 hold Mickey De La Ratones (nickname)
B2
=WEBSERVICE("http://e.anyoupin.cn/eh3/?preg_match~^\S+\s([^(]+)\s\(~" & A2 & "~1")
