+ Start a Discussion
Prince VenkatPrince Venkat 

Formula Field for text Field

How to write a formula field fetching the first 3 digit of text field


Thanks in advance
Best Answer chosen by Prince Venkat
Sai PraveenSai Praveen (Salesforce Developers) 
Hi Prince,

You can use the below formula. Replace the Last_Name__c with the text field as per your requirement.
 
LEFT(Last_Name__c, 3)

If this solution helps, Please mark it as best answer.

Thanks,

 

All Answers

Sai PraveenSai Praveen (Salesforce Developers) 
Hi Prince,

You can use the below formula. Replace the Last_Name__c with the text field as per your requirement.
 
LEFT(Last_Name__c, 3)

If this solution helps, Please mark it as best answer.

Thanks,

 
This was selected as the best answer
vaani krvaani kr
Hi  Prince Venkat,

LEFT   will  Returns the specified number of characters from the beginning of a text string.

LEFT(Name, 3)

Thanks,
vaani