bendy_leather2
New Member
- Joined
- Sep 3, 2020
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
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!
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!