banner_ad

Change case in excel

This query is : Resolved 

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)

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


CCI Pro

Similar Resolved Queries


loading


Unanswered Queries



CCI Pro
Meet our CAclubindia PRO Members

Follow us
add to google news



Answer Query



Company
ARTICLESHIP 17 May 2026
CA Article /Trainee

Malik Sunil & co

New Delhi

CA Foundation

View Details
Company
26 April 2026
Chartered Accountant

Source HR

Mumbai

CA

View Details
Company
04 May 2026
Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details
Company
11 May 2026
AUDIT INTERN

M/S K.K.KHANNA AND COMPANY

Noida

CA Foundation

View Details
Company
ARTICLESHIP 05 May 2026
ARTICLED ASSISTANT

JS ADVISORS

New Delhi

CA Inter

View Details
Company
25 April 2026
Tax Executive/Manager

BDMV & Co, Chartered Accountants

Mumbai

CA Final

View Details
Company
19 May 2026
Accountant

ca kunjan

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 24 April 2026
Article

Rohit Doshi And Associates

Pune

CA Foundation

View Details