Skip to main content

Get Initials from Name with more then First- and Lastname

  • October 30, 2024
  • 0 replies
  • 7 views

karimzynera
Forum|alt.badge.img+5

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

Be the first to reply!