Extract text from cell string using delimiters "/" into separated columns
Hi all,
I've been fiddling with this for some time. I need to extract the text between the two / /
In this case, it should return "PPA."
I've explored a solution using the following post, but I can't seem to achieve success. Any suggestions?
Extract text from Cell String using delimiters “|” into separated columns — Smartsheet Community
Best Answers
-
Hi @Kayla Q
Here is the formula:
=MID([Legal Tracker Short Matter name]@row, FIND("/", [Legal Tracker Short Matter name]@row) + 1, FIND("/", [Legal Tracker Short Matter name]@row, FIND("/", [Legal Tracker Short Matter name]@row) + 1) - FIND("/", [Legal Tracker Short Matter name]@row) - 1)
Tomasz Giba
-
Hi @Kayla Q
Here you go:
1.
=RIGHT([Legal Tracker Short Matter name]@row, LEN([Legal Tracker Short Matter name]@row) - FIND("/", [Legal Tracker Short Matter name]@row, FIND("/", [Legal Tracker Short Matter name]@row) + 1))
2.
=MID([Legal Tracker Short Matter name]@row, FIND("CC", [Legal Tracker Short Matter name]@row), FIND("/", [Legal Tracker Short Matter name]@row) - FIND("CC", [Legal Tracker Short Matter name]@row))
Tomasz Giba
Answers
-
Hi @Kayla Q
Here is the formula:
=MID([Legal Tracker Short Matter name]@row, FIND("/", [Legal Tracker Short Matter name]@row) + 1, FIND("/", [Legal Tracker Short Matter name]@row, FIND("/", [Legal Tracker Short Matter name]@row) + 1) - FIND("/", [Legal Tracker Short Matter name]@row) - 1)
Tomasz Giba
-
@Tomasz Giba that worked! Thanks!
-
@Tomasz Giba could you tell me:
- how to return the "Onica Group" part of the first line?
- How to return the number stargin in CC?
I've been fiddling with this formula for over an hour and I can't figure it out. I don't understand the logic behind it :(
-
Hi @Kayla Q
Here you go:
1.
=RIGHT([Legal Tracker Short Matter name]@row, LEN([Legal Tracker Short Matter name]@row) - FIND("/", [Legal Tracker Short Matter name]@row, FIND("/", [Legal Tracker Short Matter name]@row) + 1))
2.
=MID([Legal Tracker Short Matter name]@row, FIND("CC", [Legal Tracker Short Matter name]@row), FIND("/", [Legal Tracker Short Matter name]@row) - FIND("CC", [Legal Tracker Short Matter name]@row))
Tomasz Giba
-
Thanks, @Tomasz Giba!
For 2, I finally got this to work yesterday:
=MID([KLG Matter Name]@row, FIND("-", [KLG Matter Name]@row) + 1, 11)
It's not as effective as yours, though, as the number of digits may change.
Appreciate you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!