How to change case with UPPER LOWER and PROPER

In this worksheet, we have two columns that contain names.

In column D, I’ll add a formula that capitalizes the first name using theUPPER function.

The UPPER function takes just one argument: the text you want in upper case.

When I add the formula and copy it down, we’ll get all first names in uppercase text.

What if you need both first and last names in upper case?

This formula can be as flexible as you need.

In column E, let’s convert the names to lower case using theLOWER function.

First, I’ll add a domain name above the list to keep this information in only one place.

I’ll use the generic name “acme.com” for the domain.

Now I can assemble the email address using a formula.

Once I add the names, I need to add the “@” symbol and the domain.

Finally, let’s try out thePROPER function.

The PROPER function capitalizes the first letter only of each word you provide.