Extracting Specific string from a cell content

[AsgiE]

I need help in getting a formula that will be able to extract a specific word from a string within a cell ie:
I want to extract "Recoverable" from a string in a cell and the word Recoverable can be at any location within that cell. I cannot use Mid as I dont know the starting point.
I could use the letter R as the search point for Match to compute the starting point for the Mid formula but need help in putting it together.

Appreciate the help.

Thanks
Asgi

 

[Robert Mika]

Do you want to extract or to check if is there?

 

[Cindy Ellis]

This formula should do what you need:
=MID(A1,SEARCH("recoverable",A1),11)

Hope that helps,


...and what Robert said

 

[AsgiE]

I need to Extract
Thanks

 

[AsgiE]

This works perfectly!
Thanks

 

[Rick Rothstein]

Try this formula...

=IF(COUNTIF(A1,"*recoverable*"),"Recoverable","")

 

[BenMiller]

Or =IF(FIND("recoverable",A1),"recoverable","")

 

[Rick Rothstein]

Or =IF(FIND("recoverable",A1),"recoverable","")

You will want to control the error generated when the FIND function cannot find the text. Also, maybe use SEARCH in place of FIND to make it case insensitive?

 

[T. Valko]

Or =IF(FIND("recoverable",A1),"recoverable","")

You will want to control the error generated when the FIND function cannot find the text. Also, maybe use SEARCH in place of FIND to make it case insensitive?

=IF(COUNT(SEARCH("Recoverable",A1)),"Recoverable","")

Although Rick's suggestion is the best.

 

[BenMiller]

You will want to control the error generated when the FIND function cannot find the text. Also, maybe use SEARCH in place of FIND to make it case insensitive?

You are correct! I wrote it in haste.