Excel 2010 search a cell from a list of values and partial replace with ""

[bcain]

Hi All, this is my first post. I am using Excel 2010 and I enter a string into cell A1. I then want to search this cell from a list of values looking for a match and replace that with nothing "". ie: I enter w480-krusty-01 into Cell A1. I then want to search cell A1 from a list of values (w240-, w240_,b480-, b480_,w480-,w480_) to see if there is a match and in this instance there is a match so the result would be krusty-01 (the w480- has been replaced with nothing). THANKYOU for your help, Brian

 

[Arithos]

Thankyou Sturla, it works Gr8. All the best, Brian

Its all gooD!