This video tutorial demonstrates how to use the LEFT and UPPER functions in excel.

Download Microsoft Excel

In this example, we have a fictional address list in which part of the data is in all caps and the rest is in sentence case. Additionally, some zip codes have the additional 4 digits and for this example, we only want to use 5-digit zip codes.

We use the UPPER function to change all the text to uppercase and the LEFT function to choose only the first 5 digits of the zip code. Also shown is paste values.

Video recorded using Cam Studio (

Also be sure to check out my additional video tutorials on my YouTube channel.

Thanks for watching, I hope this was helpful to you!

Become Amazing at Excel: Recommended Reading