Lesson: 06 | Initials of a Contact

User Story

Calculate a formula field which displays the Initials of a Contact

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.

You need to login to have access to the quizzes.

Mastered by 46 users.

Exercises

A. Administrator | Exercises (59 lessons)

B. Flow Builder | Exercises (41 lessons)

C. Apex Beginner | Exercises (78 lessons)

D. Apex Intermediate | Exercises (90 lessons)

E. Integration | Exercises (4 lessons)

F. Lightning Web Component (LWC) Exercises (14 lessons)

Go to top

Login to your account

Lesson: 06 | Initials of a Contact

User Story

Exercises