If you imported or copied text into your worksheet and the case doesn’t look quite the way you want it to, you can use text functions to quickly change it. In Excel Online, you can use the UPPER, LOWER, or PROPER functions to change text to uppercase, lowercase, or proper (sentence) case.
In the example below we’ll change the customer names in column A to proper case so that the first letter in each name appears capitalized.
If needed, insert a column next to the column that has the text you want to change.
In cell B2, type =PROPER(A2), and press Enter.
Note: If you want to change text to all lowercase, you would type =LOWER(A2) and for uppercase, =UPPER(A2).
To apply the same text case to the other names, you can fill down the formula by selecting cell B2 and double-clicking the fill handle.
Delete the first column
After you’ve changed the text case, you can get rid of column A. But first convert function references in column B to values. Here’s how:
Select the column with the function reference (column B) and click Copy.
Click cell A2 > Paste and pick Paste Values.
Right-click the column B header and pick Delete Columns.
For more information about other text functions, see Text functions (reference).