A client once sent me an Excel file containing 500 names in lower case and wanted to know if there was a simple way to convert them to UPPER CASE.

Spoiler alert – there is!

In this video you’ll learn how to:

  • Convert text from lower case to UPPER CASE
  • Convert text from UPPER CASE to lower case
  • Convert text to Proper Case (First Letter Of Each Word In Caps)
  • Convert text to Sentence case (First letter of the first word is in caps)

This can be done with formulas or Power Query and in this video I’ll show you both methods


Convert Text Using Formulas

Convert Text Using Power Query