I have a cell with group of string. I want to extract a particular text which is dynamic but is surrounded by statis text. How do i get that dynamic text??
Company: IBM Value:100
Company: TCS Value:100
I need the valu IBM and TCS from above text.