Extract partial string data 1

[YANKRAY]

Using Excel 2007.

I have a column with text in the cells.
Each Cell has the string "REMOV", "INTALL", or "INSP" in it.
It could be the word REMOVE,REMOVAL, INSTALL, INSTALLATION, INSPECTION, INSP but the string is there somewhere.

How can I write a formula that finds one of the three string values and gives the result as "REMOVE", "INSTALL", or "INSPECT".

Thanks,
Ray

 

[AnotherHiggins]

Assuming the data is in column A:
[tab][COLOR=blue white]=If(IsNumber(Search("REMOV", A2)), "Remove", If(IsNumber(Search("INSTAL", A2)), "Install", If(IsNumber(Search("INSP", A2)), "Inspect", 0)))[/color]

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[YANKRAY]

John,

Thank you very much. This is exactly what I needed.

Ray