Hi everyone,
Stuck with a small query regarding identifying specific text string in a cell filled with text.
e.g. cell A2 = alpha, bravo, charlie, delta, eta, phi [single instances
cell A3 = alpha delta phi eta [single instance]
cell b1=alpha
cell b2=bravo etc.
Identification should be in the following format:
Excel.jpg
I've tried using the formula = [len(A2)-len(substitute(A2, b1, "")]/len(B1)
But have been getting haywire results.
Can I get some help with this asap?
Mods: please shift/merge this thread in case I've posted it in a wrong section.
Bookmarks