Ever needed to get the initials of a name that had more than first and last name plus some weird dashes and what not?
Try this formula, which can also be used to get the firstname and lastname with a workaround of find() and search() which only returns the position of the first space in the string
LEFT({Name},1) & LEFT(REGEX_EXTRACT(Name,"\\s(\\S+)$"),1)
I hope this helps!
