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...
Request a quote
- We offer a price match guarantee.
- No hassle set-up. Fully branded LMS with single sign-on and API integration.
- Desktop and mobile compatible. Train anywhere, anytime.
Once submitted, a member of our team will be in touch to talk you through your training options.