Hello, I'm trying to write a formula that will read text in a cell, and if that cell contains one word somewhere in its sentence, then it will produce a certain output.
For example, if the cell I reference contains the word "Venture" somewhere within is string of text, I want my formula to output "Venture Capital Fund". Is this possible?
Bookmarks