how to change the capital letters to small letters & vice versa using EXCEL FUNCTIONS
please tell me its urgent.
Pradip
(Accountant/Management)
(106 Points)
Replied 13 June 2010
In MS Excel you can use =LOWER(Cell Reference) for capital to small letter. Let me know it is helpful for you or not.
SIVASIVA
(FCA, Future CA)
(4935 Points)
Replied 13 June 2010
thanks a lot pradip, so i presume for that vice versa, it is "UPPER"
Pradip
(Accountant/Management)
(106 Points)
Replied 14 June 2010
Yes Dear, For small to cap you can use "UPPER" function.
LIVE Course on Foreign Exchange Management Act (FEMA)(with recording)
LIVE Course on Foreign Exchange Management Act (FEMA)(without recording)