Which Excel function converts text to all lowercase?

Which Excel function converts text to all lowercase?

• A. UPPER(A7)
• B. PROPER(A7)
• C. CONCAT(A7)
• D. LOWER(A7)

Answer: (D)

Converting text to lowercase in Excel is done with the LOWER function. LOWER takes a text string and returns that text with all letters turned to lowercase. Using LOWER(A7) applies this to whatever text is in cell A7, so if A7 contains “Excel Tips,” the result would be “excel tips.” This differs from UPPER, which makes all letters uppercase, and PROPER, which capitalizes the first letter of each word. CONCAT, on the other hand, combines strings and doesn’t change their case by itself. So to get all lowercase text, you use LOWER.

Converting text to lowercase in Excel is done with the LOWER function. LOWER takes a text string and returns that text with all letters turned to lowercase. Using LOWER(A7) applies this to whatever text is in cell A7, so if A7 contains “Excel Tips,” the result would be “excel tips.” This differs from UPPER, which makes all letters uppercase, and PROPER, which capitalizes the first letter of each word. CONCAT, on the other hand, combines strings and doesn’t change their case by itself. So to get all lowercase text, you use LOWER.