Excel Function of the Month – LOWER


The Excel Function of the month is

LOWER

Description

Converts a text string to all lowercase letters

Usage

The LOWER function does just what it says. It converts text in a cell to lowercase. The UPPER function does the opposite.

This is an example of the basic use of the LOWER function.

Here an example of using LOWER inside of another function.

Check out my Excel posters for your classroom

Excel-Functions-PostersI have created posters that you can stick up in your class. There are 33 posters. Below is an index of what functions are available and a sample sheet (to the right) showing what the posters look like. You can purchase them from the Tech Teachers online shop.

Functions covered

AND, AVERAGE, CONCATENATE, COUNT, COUNTA, COUNTBLANK, COUNTIF, DATE, FIND, INT, LARGE, LEFT, LEN, LOWER, MAX, MEDIAN, MID, MIN, MODE, NOW, OR, POWER, RAND, RANDBETWEEN, RIGHT, ROUND, SMALL, SUM, SUMIF, TIME, TODAY, UPPER, VLOOKUP

Find out more about the posters here

Similar Posts: