small to capital & vice versa

Others 563 views 3 replies

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

please tell me its urgent.

Replies (3)

In MS Excel you can use =LOWER(Cell Reference) for capital to small letter. Let me know it is helpful for you or not.

thanks a lot pradip,  so i presume for that vice versa, it is "UPPER"

Yes Dear, For small to cap you can use "UPPER" function.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register