Extract text from cell string using delimiters "/" into separated columns

Kayla Q

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

Tomasz Giba

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

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)

Kayla Q

@Tomasz Giba that worked! Thanks!

Kayla Q

@Tomasz Giba could you tell me:

1. how to return the "Onica Group" part of the first line?
2. 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 :(

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))

Kayla Q

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!