Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Capitalise first name in Formua field

Topic Labels: Formulas
2111 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kosta_Kondraten
7 - App Architect
7 - App Architect

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

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, "(?:.)([^ ]*)")))

Screen Shot 2022-06-21 at 7.25.14 PM