get the text from one string

[jaffirahamed1]

Hi Formula Gurus,

In this attachment, i try to get one particular in a bunch of string, i have a list of text which the string having that one text, i can able to find by using "text to columns", the problem is the text is in different entity. so i used the formulas i showed in the sample file to identify my desired text in that string. I want this entire calculation in one formula.
hopefully u understand what i am trying to propose.

thanks in advance