function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Adrian-EAdrian-E 

Capitalization Formula

I am looking to create a formula that will capitalize the first letter of each sentence in a field.
 
It would change:
customer wants a refund to
Customer Wants A Refund
 
 
Is there any formula that can do this?
TGHTGH

I am also trying to find a solution for this. I've created a workflow rule that performs the following:

 

Criteria:

BEGINS(FIELDNAME,"a")

 

Field Update:

UPPER(LEFT(FIELDNAME,1) & "The rest of the text in the field name"

 

I've tried doing:

UPPER(LEFT(FIELDNAME,1) & (FIELDNAME - (LEFT(FIELDNAME,1))

 

And that doesn't work because Salesforce will only allow numbers or dates when using mathematic operators. Which is really, really smart. Why would we ever want to use variables?