Microsoft 365 vs Office 2019, Microsoft upgrade options explained
If you’ve entered data into Excel and it’s all UPPER case but you’d prefer it to be lower or Title Case you can change it quickly.
In a blank column enter one of the following formulas:
=lower(cell reference that you want to change) – converts the cell contents to lowercase
=upper (cell reference that you want to change) – converts the cell contents to uppercase
=proper (cell reference that you want to change) – capitalises the first letter a word
If you want to copy the new format to the existing cells, select the newly formatted cells and either right click and select copy, use the keyboard shortcut of CTRL+C or click the copy icon. Select where you want to paste the text, right click and choose Paste, Special, Values.
You can now delete the cells that contain the original formula.
Related posts
