Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Get Initials from Name with more then First- and Lastname

298 0
cancel
Showing results for 
Search instead for 
Did you mean: 
karimzynera
5 - Automation Enthusiast
5 - Automation Enthusiast

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!
0 Replies 0