Hello,
Thank you in advance for any suggestions! I have a corpus of written comments and would like to identify the number of acronyms that appear in each cell of text. Of course, there is no perfect way to do this, but one idea I had is to create an excel function that counts the number of times between 2 and 5 capital letters appear as consecutive characters. I chose 5 as the high end of the range because very few acronyms are more than 5 letters long and a function that indiscriminately identifies consecutive capital letters would incorrectly identify text that is written in all caps as an acronym.
Below is an illustration of what I need. I have the sentences in the "TEXT" column and would like a function that produces the values in the other column.
Any ideas would be greatly appreciated!! Thank you so much for taking the time to help!
Thank you in advance for any suggestions! I have a corpus of written comments and would like to identify the number of acronyms that appear in each cell of text. Of course, there is no perfect way to do this, but one idea I had is to create an excel function that counts the number of times between 2 and 5 capital letters appear as consecutive characters. I chose 5 as the high end of the range because very few acronyms are more than 5 letters long and a function that indiscriminately identifies consecutive capital letters would incorrectly identify text that is written in all caps as an acronym.
Below is an illustration of what I need. I have the sentences in the "TEXT" column and would like a function that produces the values in the other column.
Any ideas would be greatly appreciated!! Thank you so much for taking the time to help!
TEXT | NUMBER OF ACRONYMS |
This sentence has no acronyms | 0 |
I launched a word-of-mouth marketing (WOMM) campaign. | 1 |
I have experience in BTC and BTB | 2 |
This sentence has no acronyms | 0 |
Neither does this one. | 0 |
He worked at a PR agency | 1 |
THIS SENTENCE IS ALL CAPS | 0 |