Extract capital letters from a string

[dannytvb]

I want to be able to extract capital letters from a string (name of a type of event) to create its ID CODE.
This way I can keep my ID CODE as a formula, not manually, and still control how it comes out through the capitalizing of letters in the name.

For example:

 NeuroGym = NG
 Business Meeting = BM
 Annual global Event = AE
 Monthly internal Event = ME
 Business Event = BE

[Sho]

If you want to remove lowercase letters and spaces, that's easy.

REGEX_REPLACE({Name},"[a-z ]","")

[Alexey_Gusev · Accepted solution]

I thought exactly the same way, but was too lazy and asked chatbot. Seems like chatbot offered better solution

REGEX_REPLACE({YourTextField}, "[^A-Z]", "")

[Sho]

That's certainly better

AIChatbot is very informative.

[kuovonne]

Lol. I was lazy and figured someone else would type the answer.

[dannytvb]

Worked beautifully, thank you 😃