Certification Course on Practical Filing of Income Tax Returns
Certification Course on Prompt Engineering Mastery for Finance Professionals
3-Day Session on Input Tax Credit (ITC)
AI for Accounting, GST & Finance Practice
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
J SINGH & ASSOCIATES
Ahmedabad
CA Inter
Right way solution
Ajmer
CA
hitesh chandwani & co
Pune
B.Com
S.K Gairola & CO
New Delhi
Sanjay K Pathak & Associates
Noida
Graduate (Any)
mgirt & co
Bengaluru
SSGS and Associates
Chennai
GM Corporate Solutions
CA Final
India's largest network for finance professionals
Alternatively, you can log in using: