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
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!