Capitalise first name in Formua field

Topic Labels: Formulas
1446 1
Showing results for 
Search instead for 
Did you mean: 
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