+ Start a Discussion
Maddy6161Maddy6161 

How create a formula field for Auto Catch 1st 3 word from City + last 2 word from Country field

City Field             Country Field

Pune                    India

Formula Filed : PUNIN            like this
Best Answer chosen by Maddy6161
Ravi Dutt SharmaRavi Dutt Sharma
Try below formula, let me know if it works.
 
LEFT(City__c, 3)  + LEFT (TEXT(Country__c),2)

 

All Answers

Ravi Dutt SharmaRavi Dutt Sharma
Hey,

Create a formula field of type Text and paste below formula in it
 
LEFT(City__c, 3)  + LEFT (Country__c,2)

 
Maddy6161Maddy6161
Thanks Ravi  :   Country__c is a picklist field. 
Ravi Dutt SharmaRavi Dutt Sharma
Try below formula, let me know if it works.
 
LEFT(City__c, 3)  + LEFT (TEXT(Country__c),2)

 
This was selected as the best answer
Maddy6161Maddy6161
Thanks Ravi