banner_ad

how to convert lower case to upper

1431 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
ARTICLESHIP 30 April 2026
Article Assistant

J SINGH & ASSOCIATES

Ahmedabad

CA Inter

View Details
Company
10 May 2026
Finance specialist

Right way solution

Ajmer

CA

View Details
Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
04 May 2026
Articleship

S.K Gairola & CO

New Delhi

B.Com

View Details
Company
05 May 2026
Accountant

Sanjay K Pathak & Associates

Noida

Graduate (Any)

View Details
Company
16 May 2026
Audit clerk

mgirt & co

Bengaluru

CA Inter

View Details
Company
ARTICLESHIP 15 May 2026
Audit Assistant / Article Trainee / Intern

SSGS and Associates

Chennai

CA Inter

View Details
Company
ARTICLESHIP 27 April 2026
CA Articled Assistant

GM Corporate Solutions

Noida

CA Final

View Details