Knowledge Base
How can we help?
Full Site Search

How to set text to sentence case with formulas in Ragic?

For example, let's say you want to set text to sentence case using formulas for the "Description" field.

What you need to do is to create a new field and apply this formula:

TOUPPERCASE(LEFT(A8, 1)) + TOLOWERCASE(RIGHT(A8, LEN(A8)-1))

You can replace A8 with the field you would like to reference.

After applying that formula, your new field will populate the sentence on the "Description" field on A8 with the first letter capitalized.

Top of Page
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Ragic Pricing
Applications
Keep in touch:
Blog
Facebook
YouTube
Ragic, Inc.
1-888-666-8037
Terms
Privacy
info@ragic.com