Return text from within the text by matching certain keyword

[msharma864512]

Hi,

I am looking for a formula which searches for a particular text from a column and return the desired text into column C.

For example, the formula will look for text "Submitted" in column A, and wherever it finds the text, then it will exclude the text "Submitted" and just return the date in adjacent cell of column C.

As an example, when the formula searches through column A for text "Submitted", then it will find the first cell with text "Submitted" in cell A6, then it will just return the date from that cell to C6 as "July 26 2006". It will repeat the same exercise for all the cells.

Regards,
Manish

 

[AliGW]

In C3 copied down:

=IFERROR(IF(SEARCH($C$2,A3)=1,SUBSTITUTE(A3,"Submitted ",""),""),"")

 

[msharma864512]

Thank You Ali for your help

 

[AliGW]

You're welcome!

 

[bosco_yip]

Another approach,

=MID(A3,FIND("Submitted ",A3&"Submitted ")+10,99)

Regards
Bosco