how to convert a complete sheet in Excel in lower case character to upper case - with a single command?
cope the excel to word and select all
then press SHIFT + f3
Download and install following addins on your PC:-
https://www.asap-utilities.com/
After installation select all sheet and go to Text->Convert Uppercase.
Hope this will workout..
Hi Dipak,
For lower case just do the following
Type=lower() and select the text which you want to convert into lower case in the braces. You can do this in excel sheet itself.
Also try =Upper for Upper and =Proper for Proper arrangement of data
Thanks for the info frnd.
Thanx for useful info.
Your are not logged in . Please login to post replies Click here to Login / Register
More recent discussions | Post
Interactive Media Pvt Ltd.
New Delhi
CA Inter
Mugdha Art Studio
Hyderabad
CA
Murali and Sumeet Chartered Accountant
Bengaluru
CA Foundation
Pravin Sarvaiya
Mumbai
Getmyca Consultant Pvt Ltd
MANUJ SHARMA AND COMPANY
Noida
Aviv Global Private Limited
Ahmedabad
KK & Company Chartered Accountant
Pune
India's largest network for finance professionals
Alternatively, you can log in using: