Use the LOWER function to convert text from uppercase to lowercase - Text Functions - Microsoft Excel Tutorials

To convert all letters to lowercase in a text string, use the LOWER function. This function has the following syntax:

LOWER(text)

text: Text to be converted to all lowercase letters. The text can be either a reference or a text string.

To convert a text string to lowercase:

1. In cells A2:A8 type any text in uppercase letters.
2. Select cells B2:B8 and type the following formula: =LOWER(A2).
3. Press <-Ctrl+Enter->.

Watch the Video Tutorial - https://www.youtube.com/watch?v=SD2qZjFk-lo

Hope You Like This Tutorial - Give Comments