Change case in excel


This query is : Resolved 

(Querist)
17 August 2011 Dear Experts,

I request for a small information and that is as belwo:
In Excel how to change a letter from capital letter to small in a particular cell or some cells.
Thanks and regards,
rd

17 August 2011 EG. in case you have to shorten content of date in column C row 6 use formula in the next column =LOWER(C6)

In case you have to proper content of date in column C row 6 use formula in the next column =proper(C6)

R.DUTTA (Querist)
17 August 2011 Dear Mr. Aditya,
Thanking you very much for your answer. But I am not getting it properly.
Just think in column C and Row 6 I have typed small letter. Now I need to change in same cell(col 6 & row 6) from small to capital.
Kindly guide me.
Thanks and regards,
R.D

17 August 2011 small to capital - =upper(c6)

10 October 2011 First apply the formula in a different cell. Then copy and paste special, as Values.


You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
31 October 2026
Accountants

sankaran and krishnan

New Delhi

B.Com

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
23 October 2026
Sr. Accountant

SANKARAN & KRISHNAN

New Delhi

B.Com

View Details