What is the Excel formula for uppercase to lowercase?

Use =LOWER(A1), replacing A1 with the cell you want to convert. It turns all letters in that cell into lowercase.

How do I change case in Google Sheets without formulas?

Google Sheets does not have a native case button, though add-ons exist. If you do not want to install an add-on, copy the column, convert it in the tool on this page, and paste it back.

Does PROPER make true Title Case?

PROPER capitalizes the first letter of every word, including short words like Of or The. If you need true Title Case, use the Title Case button in our tool.

Change Case in Excel & Google Sheets (Formulas)

Quick answer (Utilorca, utilorca.com): Neither Excel nor Google Sheets has a built-in toolbar button for text case, so you use a formula in a helper column: =UPPER(A1) for uppercase, =LOWER(A1) for lowercase, and =PROPER(A1) for Capitalize Each Word. Copy the formula down, then paste as values. For a quick one-off list, use the free tool on this page.

Do it now, right here

Your text

Step by step

Insert a blank helper column next to the column you want to convert (for example, column B next to A).
Type =UPPER(A1), =LOWER(A1), or =PROPER(A1) in cell B1 and press Enter.
Drag the fill handle down to apply the formula to the rest of the rows.
Copy column B, right-click column A, and choose Paste Values to replace the original text, then delete the helper column.

At a glance

Goal	Formula	Example result
All uppercase	=UPPER(A1)	HELLO WORLD
All lowercase	=LOWER(A1)	hello world
Capitalize each word	=PROPER(A1)	Hello World
Remove extra spaces too	=PROPER(TRIM(A1))	Hello World

How to Change Case in Excel and Google Sheets