Extract string between delimiters

[luisj]

I would like to extract the tickets HD, SNAP, AAL1 from these formulas
Contract Options HD/18M21P285:xcbf 2015737988
Contract Options SNAP/18M21C60:xcbf 2014664811
Contract Options AAL1/21K21C24:xcbf 2013413727
I tried the formula =MID(D16,FIND(" ",D16)+1,FIND("/",D16)-FIND(" ",D16)-1) but I got
“Options AAL1”. What is missing, and what is the meaning of +1 and -1 in the end? What is the logic of this formula?
Thanks

[Kaper]

If your sample data is representative such formula would do:

Please Login or Register  to view this content.

as for +1 or -1 these are corrections not to include in found text the character you were searching for "/", " " etc.
You got two words, because formula looks for the first space and for first slash and extracts everything between

[FlameRetired]

Hello luisj. Welcome to the forum.

See if you can adapt the attached to your live data.

With a lookup table in column D (or other) and inputs in column A try this formula in column B.

Please Login or Register  to view this content.

	A	B	C	D
1	Contract Options HD/18M21P285:xcbf 2015737988	HD		HD/
2	Contract Options SNAP/18M21C60:xcbf 2014664811	SNAP		SNAP/
3	Contract Options AAL1/21K21C24:xcbf 2013413727	AAL1		AAL1/

[Fluff13]

Another option if all data follows the patter of those examples

Please Login or Register  to view this content.

[luisj]

Fluff13: Elegant solution, thank you! But I don't understand the -18 in the end...
Kaper: Thanks.
Flame Retired: purpose is to extract the ticket withou creating any extra column as a reference

[Fluff13]

Glad to help & thanks for the feedback

But I don't understand the -18 in the end...

We need to subtract 1 from the find so that it doesn't return the / and as we're removing the 1st 17 characters from the cell we need to subtract 17 as well, hence -18

[FlameRetired]

......
Flame Retired: purpose is to extract the ticket withou creating any extra column as a reference

I didn't see any mention of that above. In that case do this (no extra columns)

Please Login or Register  to view this content.