FIND method with LIKE operator

[bendy_leather2]

Excel - Office 365

Hi all,

I was hoping you kind Excel folks may be able to help me out. I am trying to find acronyms within a workbook (based on the formatting of 1 or more uppercase letters, followed by 1 lowercase letter, followed by 1 or more uppercase letters.)

My question is... Is it possible to combine the LIKE operator with the FIND method? My initial idea was to utilise the FIND method to locate the acronyms and then list them on another sheet, I cant get this to work unless i specify the string itself rather than its format.

Failing that, does anyone know of a way (or throw me in the right direction) to go about searching for acronyms within a workbook?

Thanks in advance!

 

[bendy_leather2]

Thanks Peter! It's nice to know that I wasn't being a complete numpty. I appreciate the advice on the suggested changes too, I never thought about using arrays for doing things like column naming etc.
Enjoy your weekend mate, and thanks again!