+ Start a Discussion
nareshnaresh 

Records in the lead object

i am  facing issues with the data in the lead object.. some of the  names in capital and some in small and i want all my data existing and new records to be clean that is first letter should be capital and rest it must be small. Please help me sorting out yhis issue.


Thanks in advance.
PratikPratik (Salesforce Developers) 
Hi Naresh,

Here is the formula:
UPPER(LEFT(fieldname, 1)) + LOWER(MID(fieldname, 2,(LEN(fieldname)-1)))

Apply this for the field. For existing data, you will need to create a formula field and then update the name (first name, last name) with dataloader.

Going forward,you can create a workflow rule which will have field update action with the above mentioned formula.

Thanks,
Pratik

P.S. If this answers you question, please mark it as "Best Answer" so it will help other community members too.