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
ARTICLESHIP 07 October 2026
Article assistant

S.K.Bajpai & Co.

Noida

B.Com

View Details
Company
06 October 2026
Assistant Manager - Audit and Compliance

Ravi K Jain & Co

Noida

Others

View Details
Company
ARTICLESHIP 23 October 2026
Articled Trainee

J Y & CO

Hyderabad

CA Inter

View Details
Company
23 October 2026
Sr. Accountant

SANKARAN & KRISHNAN

New Delhi

B.Com

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
08 October 2026
Accounts and Tax Associate

POOJA R TELI & CO

Pune

CA Inter

View Details
Company
15 October 2026
Senior Accountant

Continental Belting Pvt Ltd

Mumbai

B.Com

View Details
Company
16 October 2026
CA article trainee

Zerdi & Co. Chartered Accountants

Pune

CA Inter

View Details