Activity Forums Salesforce® Discussions What is the formula to count the characters in a text field? Reply To: What is the formula to count the characters in a text field?

  • Abhinav

    Member
    August 1, 2016 at 1:31 pm

    Hi Tanu,

    LEN() - returns the number of characters in a text string.

    But LEN will count spaces as well.

    If you want just CHR counts, you will need to TRIM the string and then use LEN to return the number of CHR. If you do not want to count special ASCII CHR like ();: etc you will need to adjust some code for that as well.