Need help creating a formula that will remove a certain string of text.
My use case is:
I need to remove everything within the parentheses and including the parentheses. Is this possible? I just need the name. I feel like the Replace, substitute or mid formula would put me in the right area but not able to figure it out.
Ex: John Doe (123456789)
Best Answer
-
Try this.
=LEFT([Column Name]@row, FIND("(", [Column Name]@row) - 2)If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
Try this.
=LEFT([Column Name]@row, FIND("(", [Column Name]@row) - 2)If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
That worked. Thanks for the help!
Help Article Resources
Categories
Check out the Formula Handbook template!