excel formula to search for multiple text in a cell and return value

excel formula to search for multiple text in a cell and return value

excel formula to search for multiple text in a cell and return value. There are any references about excel formula to search for multiple text in a cell and return value in here. you can look below.