
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 21, 2022 03:25 PM
I have a ‘Contact’ field with a value as follows
MICHAEL Ashworth
I have a formula field that I want to say the following:
Hi Michael,
Are you ready for something exciting… (etc.)
How can I get only the first name (remove everything after the space) - and then capitalise only the first letter.
Thank you!
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 21, 2022 07:26 PM
Try this for a {First Name}
field. It’ll work regardless of how the first name was originally capitalized:
IF(Contact, UPPER(LEFT(Contact, 1)) & LOWER(REGEX_EXTRACT(Contact, "(?:.)([^ ]*)")))
Reply
