Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 30, 2024 06:46 AM
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
