Formula to create abbreviations

Airtable Questions Fields and Formulas
1

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.

2

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]+",
  ""
)
3 Likes
3

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