ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Wildcards and Acronyms in Excel (https://www.excelbanter.com/excel-programming/363060-wildcards-acronyms-excel.html)

Phil

Wildcards and Acronyms in Excel
 
Hi, how do I use wildcards to find acronyms(all words in caps with
two or more characters) in an excel sheet?

Right now, I'm doing find [A-Z]{2,} , but it's not working.

Ideas?

Thanks,

-Phil


Phil

Wildcards and Acronyms in Excel
 

I ended up copying the sheet from excel and just using words
function.

Phil wrote:
Hi, how do I use wildcards to find acronyms(all words in caps with
two or more characters) in an excel sheet?

Right now, I'm doing find [A-Z]{2,} , but it's not working.

Ideas?

Thanks,

-Phil




All times are GMT +1. The time now is 03:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com