Hi im looking for formula to search 2 cells,find partial match and return cell value.
Where the word "new" is found.

A1 = new blue shorts
A2 = blue jeans

So B1 would return the cell content of A1, answer new shorts
Thanks