If you want to convert the text to lowercase, type =LOWER(B2) instead. Insert a new column next to the one that contains the text you want to convert text case. How to Change Text from Lowercase to Uppercase in Excel 2016?
This tutorial will walk you through the steps of changing text from lowercase to uppercase in Excel 2016. Fortunately you can use a formula to accomplish such a specific task.
How can I change the case of selected cells (to lower or upper or whatever) in Excel? Unlike Microsoft Word, Microsoft Excel doesn’t have a keyboard shortcut for changing the capitalization, or case of selected text.