Change case in excel

This query is : Resolved

R.DUTTA (Querist)
Follow

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

Aditya Maheshwari

Aditya Maheshwari (Expert)
Follow

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

R.DUTTA (Querist)
Follow

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

Aditya Maheshwari

Aditya Maheshwari (Expert)
Follow

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

CA Siddhartha Bhardwaj

CA Siddhartha Bhardwaj (Expert)
Follow

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

Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

SUMAN SAHA

Fredrick Samraj

CA.Pinank Arvindbhai Shah

Sunaram Marndi

Narendra

Subscribe Now

Change case in excel

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Senior Executive

Manager- Finance and Compliance

GST CONSULTANT

GST CONSULTANCY

Accountant

CA Final

Article Assistant

Associate CA