small to capital & vice versa

SIVASIVA (FCA, Future CA) (4935 Points)

13 June 2010

how to change the capital letters to small letters & vice versa using EXCEL FUNCTIONS

please tell me its urgent.

Reply
Follow
Share

3 Replies

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.

2 Like

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.

Start a New Discussion