Return Text from the Left of "("
Hello,
I need to return a 11 characters from the left of a parenthesis from a string of text.
For example
T0000000001
T0000000002
T0000000003
(Primary Case)
I need the formula to return only the 11 characters from the left of "(Primary Case)"
T000000003
Best Answer
-
Hi @Miles Allison,
If this text string is in a single cell, you can do this using:
=MID([Column Name]@row, FIND("(", [Column Name]@row) - 12, 11)
Obviously you need to change out "Column Name" for the header of the column the text is in, but this should work providing there is only a single instance of an open bracket in your text string.
Hope this helps!
Answers
-
Hi @Miles Allison,
If this text string is in a single cell, you can do this using:
=MID([Column Name]@row, FIND("(", [Column Name]@row) - 12, 11)
Obviously you need to change out "Column Name" for the header of the column the text is in, but this should work providing there is only a single instance of an open bracket in your text string.
Hope this helps!
-
That worked! thanks so much
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!