Demystifying Section 68 to 69C of the Income tax Act, 1961
Certification Course on Tally With AI
GST on Infrastructure Sector
AI and Excel (Start the New Year with New Learnings)(Recorded Courses)
AI in Excel for the Modern Professional: Excel, PPT & Office Productivity
MS-Excel & AI Live Training
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
India's largest network for finance professionals
Alternatively, you can log in using: