From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Format text using UPPER(), LOWER() and LEN() functions
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Format text using UPPER(), LOWER() and LEN() functions
- [Instructor] Have you ever had data in your workbook that was all lowercase and you needed it to be uppercase? If so, then these are the functions for you. In this video, we'll learn how to use the UPPER, LOWER, and LEN, which is the length of the characters in a cell. Let's jump right in to our Upper_Lower workbook and take a look, first, at UPPER. Our company names are all upper and lowercase, but to quickly change all of the text to uppercase, we can use this wonderful UPPER function. I'll click in C2 and type =UPPER, Tab, select B2, which is the text that I'd like to transform to uppercase, close my parentheses, and hit Enter. And that quickly, that data has been reformatted and is all in uppercase. Now, we can do the same if we want to take something from upper and lowercase, such as it is now in the B column, or to all lowercase. Now, what if we use the LOWER function to change everything that's in uppercase to lowercase? Let's click in D2 and type =LOWER, I'll Tab to step…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Insert relative, absolute, and mixed references8m 7s
-
(Locked)
Reference named ranges and named tables in formulas3m 35s
-
(Locked)
Using the AVERAGE(), MAX(), MIN(), and SUM() functions3m 11s
-
(Locked)
Count cells using the COUNT(), COUNTA(), and COUNTBLANK() functions2m 41s
-
(Locked)
Perform conditional operations using the IF() function4m 13s
-
(Locked)
Format text using the RIGHT(), LEFT(), and MID() functions2m 36s
-
(Locked)
Format text using UPPER(), LOWER() and LEN() functions2m 21s
-
(Locked)
Format text using the CONCAT() and TEXTJOIN() functions4m 42s
-
(Locked)
Challenge: Perform operations using formulas and functions28s
-
(Locked)
Solution: Perform operations using formulas and functions4m 55s
-
(Locked)
-
-
-