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 15 September 2026
Freelance Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
19 September 2026
Finance Manager

Mugdha Art Studio

Hyderabad

CA

View Details
Company
ARTICLESHIP 07 September 2026
Article/ Paid Assistant

Murali and Sumeet Chartered Accountant

Bengaluru

CA Foundation

View Details
Company
19 September 2026
CA/Semi-CA/BCom

Pravin Sarvaiya

Mumbai

CA Inter

View Details
Company
09 September 2026
Semi Qualified CA / CA Inter - 2 Groups Cleared

Getmyca Consultant Pvt Ltd

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 16 September 2026
Article Assistant

MANUJ SHARMA AND COMPANY

Noida

CA Inter

View Details
Company
09 September 2026
Chartered Accountant

Aviv Global Private Limited

Ahmedabad

CA

View Details
Company
ARTICLESHIP 21 September 2026
CA Article Assistant

KK & Company Chartered Accountant

Pune

CA Inter

View Details