CAPITAL TO SMALL CASE

CA B Anand (CHARTERED ACCOUNTANT) (198 Points)

14 September 2010  

FRENZ,

 

IN EXCEL IF YOU WANT TO CHANGE THE CASE OF A SINGLE CELL OR MULITIPLE CELL, SAY FROM CAPS TO SMALL

THEN GO TO AN EMPTY CELL AND TYPE THE FORMULA =LOWER(A3), IF THE ORIGINAL TEXT LIES IN 3RD ROW AND "A"TH COLUMN.

THEN YOU COPY THE NEW TEXT, AND USING VALUE OPTION ON PASTE SPECIAL, AND YOU CAN PASTE IT WHEREVER YOU WANT. EVEN IN THE ORIGINAL TEXT PLACE.

IF YOU WANT TO CONVERT INTO CAPS

USE

=UPPER

AND

IF YOU WNT TO DO IN TITLE CASE

USE

=PROPER              FUNCTIONS.