Question on =Mid() Formula

[VarunMV]

Good Afternoon,

I am unable to extract only required words in a string. For example it has something like this "Dear All, We have received survey from customer which is showing as No Feedback Provided for the field tech and ensure to improve the necessary,........".

I want only No Feedback Provided in the next row and there are so many rows with other wordings as well which means =Mid(text,Start_Num (Unknown), num_chrs(Unknown)).

 

[Harry Covair]

Hi VarunMV,
Assuming

• the raw text is in A1
• the required words in A2

the formula in A3 should be

=MID(A1;FIND(A2;A1);LEN(A2))

Hope this help

Harry