Hi team,

I haveexcel sheet. On first sheet in one column i have big text and on second sheet have substring. I need to extract the substring from the column of first sheet referencing to second sheet and has to return the value in new column on first sheet. For example

On First sheet i have text as " Quick brown fox jumps on lazy dog" in A2 . On second sheet has the word " fox" in A3. So i need the word "fox" has to be displayed in the new column (May be in A10) in first sheet . How do i perform it.. Which function i have to use it.. Kindly help me