Is there a more efficient formula?

I created this function because the normal Proper function will change portions of acronyms to lower case. My company uses all capitals for data and I hate it, so I had to fix it. However, it seems there must be a more efficient way to handle it. Is there some way to do an "in list" and avoid the loop? Also, how do I call this function from another module? It resides in "MyAddin.xlam" and I cannot reference from VBA.

Please Login or Register  to view this content.

How about doing a series of Find and Replace on the data?

I am unsure what you mean by that. Do you mean to manually do that one time? I use this formula extensively as I pull live data that is fully capitalized. Or do you mean writing a subroutine to do a find replace and run it as necessary?

No, I mean a generic Find and Replace function on a given value that hits all the data in one go. You would call it for each changeable value.