Lesson: 06 | Initials of a Contact

Expectation

GIVEN:

First Name: John

Last Name: Doe

EXPECTED:

J,D

Code

LEFT(FirstName, 1) & ", " & LEFT(LastName, 1)

Explanation

This formula uses the LEFT function to extract the first letter of the contact's first name and last name, and then concatenates them with a comma and a space in between using the & operator. It will display the initials of a contact with a comma between them e.g. J,D (for John Doe)

Please note that this is assuming that you have a contact object in salesforce, and the fields you are using are FirstName and LastName. If you are using different field or object, you'll have to adjust the formula accordingly.

Video