Is it possible to check any acronyms in cell string against approved list?

[Magnatolia]

hi all,

Is it possible to check all acronyms in a cell against a preapproved list? Let's say cell has "Meeting - ARB - Discussed GPO", I would want to have the formula check both uppercase words against a named range.

Is this doable?

Thanks!

 

[James006]

Hi,

As long as you have a complete list of UNIQUE acronyms ... an array formula will return your expected result ...

Cheers