Module 27: Change Text To Proper Case

27.1 Change Text To Proper Case To change the capitalisation of certain text, you can use a formula instead of wasting time deleting and retyping everything. Proper case refers to capitalising the first letter in a string and any letters that follow are lower case, like you might want to do for a title or name. To do this, first you have to create a column or row for the return value or information. Then input the formula as follows: =PROPER(reference value) This will change all of...

Get a quote

  • We offer a price match guarantee.
  • Set-up is simple, with a fully branded LMS, single sign-on and API integration.
  • It works on desktop and mobile, so your team can train wherever suits them.

Once you’ve sent your details, one of our team will be in touch to talk you through your training options.