excel formula to change capital letters to lowercas?Advertisement
How to change the case of text in Excel. Print. Email. ... UPPER - Converts all lowercase letters in a text string to uppercase. ... Type the following formula in cell B1: =LOWER(A1) - read more
Best Answer: Let's say you want to convert text from uppercase to lowercase or from lowercase to proper case to make it more readable. To change the case of text, use the UPPER, LOWER, or PROPER functions. Example The example may be easier to understand if you copy it to a blank ... - read more
Please vote if the answer you were given helped you or not, thats the best way to improve our algorithm. You can also submit an answer or check other resources.