Skip to main content
Solved

Is there a way to format ALL CAPS using a formula?

  • June 2, 2020
  • 2 replies
  • 76 views


I am wanting to know if there is a formula that can make a record use ALL CAPS like the picture. Ideally I would like for my First Name and Last Name inputs not to be in ALL CAPS, but would would like to have a formulas that mimics this style for the records.

Thank you in advance for anyone who has a suggestion!

Best answer by ScottWorld

Welcome to the community, @TiffanyZavala!

Yes! That’s what the UPPER() function is for!

If you want to make the Last Name field uppercase, just use:

UPPER({Last Name})

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:

2 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • Answer
  • June 2, 2020

Welcome to the community, @TiffanyZavala!

Yes! That’s what the UPPER() function is for!

If you want to make the Last Name field uppercase, just use:

UPPER({Last Name})

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:


  • Author
  • New Participant
  • June 2, 2020

Welcome to the community, @TiffanyZavala!

Yes! That’s what the UPPER() function is for!

If you want to make the Last Name field uppercase, just use:

UPPER({Last Name})

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:


Excellent. Thank you for your help!