how to convert a complete sheet in Excel in lower case character to upper case - with a single command?
DIPAK AGARWAL (Service) (554 Points)
03 July 2008
how to convert a complete sheet in Excel in lower case character to upper case - with a single command?
Ramesh DC
(Student)
(20 Points)
Replied 03 July 2008
cope the excel to word and select all
then press SHIFT + f3
Subodh
( )
(402 Points)
Replied 03 July 2008
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..
seetaram kumar
(CA Final (First Group Cleared))
(109 Points)
Replied 03 July 2008
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
Live class on PF & ESI Enrollment & Returns Filing(with recording)
CAclubindia
