1. Home
  2. MS Office

Excel 2010: Change Font Case With Lower/Upper Functions

This post covers how to change the font case of data in any column or row. As editing each cell in huge data set takes a lot of precious time, you may want to use Excel 2010 build-inĀ  LOWER and UPPER functions to streamline the font case.

For changing the case of alphabets in cells, you can use LOWER function to lower the case and UPPER to convert into capital letters.

The syntax of both functions is same;

=Lower(text)

You can also insert text manually or specify location of cell containing text. In the screenshots below, you can see change of font case.

895d1277290364-change-font-case-lower-upper-

896d1277290365-change-font-case-lower-upper-

Leave a comment