Thursday, November 21

Convert Text To Lowercase Propercase & Uppercase

LOWER CASE:– With the help of Lower Case formula you can convert the text into lower case from Upper case or Proper case or Improper text available in any cell. It means every letter will be convert to lower case. (a b c d)

UPPER CASE:- With the help of Upper Case formula you can convert the text into Upper case from Lower case or Proper case or Improper text available in any cell. It means every letter will be convert to Upper case. (A B C D)

PROPER CASE:- With the help of Proper Case formula you can convert the text into Proper case from Upper case or Lower case or Improper text available in any cell. It means every letter will be convert to Proper case. (a b c d ) TO Abcd

PARAMETER:- =UPPER ( Reference Cell No) / =LOWER( Reference Cell No) / =PROPER ( Reference Cell No)

FORMULA:- =PROPER( A2) / =LOWER( A3) / =UPPER( A4)

Leave a Reply

Your email address will not be published. Required fields are marked *