how to convert lower case to upper

1437 views 5 replies

 

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.


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
09 June 2026
Accounts Associate

S Madan and CO

New Delhi

Graduate (Any)

View Details
Company
22 May 2026
U.S. Financial Reporting & Consolidation Manager

Karia Overseas

Ahmedabad

CA

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
29 May 2026
Finance Head

Bhawar Sales Corporation

Chennai

Graduate (Any)

View Details
Company
21 May 2026
Associate

PWC

Kolkata

CA

View Details
Company
27 May 2026
Audit Assitant

Virender K Gupta and Co

New Delhi

B.Com

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
Featured 15 June 2026
Senior Auditor

N. Dhawan & Co

New Delhi

CA Inter

View Details