how to change the capital letters to small letters & vice versa using EXCEL FUNCTIONS
please tell me its urgent.
Menu
small to capital & vice versa
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.
Recent Threads
- Refund due to change in GST Rate Tobacco Products
- Lease related query can we rent out lease ?
- Planning of Ceased a Business i.e Closure of Compa
- Property value in 26QB
- Form 26QB Multiple Buyer/Multiple seller
- Company Formation for clothing business
- TDS on purchase 194Q
- Compensation for urban land acquisition
- Understanding section 269st
- CASH AS GIFT OR FD AS GIFT
Related Threads
CAclubindia
