Formula to create abbreviations

Is there a way to write a formula that would string together the first letters of a multi-word name?

Example:
Farmington Youth Basketball Association = FYBA

There might not always be 4 words. Some name might be made up of more or less words.

Welcome to the TableForums community!

If the first letter of every word will always be capitalized, and no other letters will be capitalized, you can use this formula.

REGEX_REPLACE(
  {Name},
  "[^A-Z]+",
  ""
)
2 Likes

Thank you @Kuovonne!!!
This worked perfectly for what I needed to do! :raised_hands: