Friday 30 August 2019

Lower Function in Excel


If you have written a message in uppercase letters and you want to change it to lowercase letters, then lower function for you. Lower function in excel converts the text in lowercase.

Syntax of Lower Function is

=LOWER(Text)


 In the example, I have taken 4 text strings in the column and apply a function (=Lower(A1)) in Column B. All uppercase characters are converted to lowercase, Number and special characters are unaffected.

No comments:

Post a Comment