How can I make an Array Formula search for a word in a cell
Posted by Jim Rickel on March 29, 2000 4:08 PM
I have an Array Formula. I want it to look for a particular word in a cell, rather than selecting the entire contents of the cell. The E column of the Outlook sheet contains multiple single word states. One of those states is "note". I want to find the word "note" regardless of it's position in the cell and count that occurance. Is there a way to do this?
Where is my Formula , thanks to Mr. Excel for alot of help with it.