FIND MULTIPLE TEXT FROM DATA

A

AK

Hi Ron,

Thanks for the solution, one more problem, your formula is not effective if
there is a typo in the base data E.g.: If Business Class has been entered as
Businessclass in the base data, then the formula fails to identify the text
business.

Any solution, as the data I am working with has lots of error like one shown
above.
 
Top