how to convert lower case to upper

 

how to convert a complete sheet in Excel in lower case character to upper case - with a single command?

 

Replies (5)

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.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
19 August 2026
Chartered Accountant - Financial Consolidation & Reporting

Synergy Keystone

Mumbai

CA

View Details
Company
ARTICLESHIP 17 August 2026
CA Article Trainee

ASC Group

Noida

CA Inter

View Details
Company
ARTICLESHIP 10 August 2026
Article Assistant

Suraj Garg and Associates

New Delhi

CA Inter

View Details
Company
14 August 2026
Article Assistant CA Articleship

Eshwar & Co Chartered Accountants - Nungambakkam

Chennai

CA Inter

View Details
Company
ARTICLESHIP 25 August 2026
CA Article's

Saini Pati Shah & Co LLP

Mumbai

CA Inter

View Details
Company
Featured 19 August 2026
Chartered Accountant

apricus india

Pune

CA

View Details
Company
ARTICLESHIP 05 August 2026
CA associate

Arun Deepak and Company

New Delhi

CA Inter

View Details
Company
29 August 2026
Chartered Accountant

Velionit Consulting PVT LTd

Mumbai

CA

View Details