Register
How to change capital letters to lowercase in excel?.
201k views
18 votes
How to change capital letters to lowercase in excel?.

User R Pelzer
by
3.9k points

1 Answer

4 votes

Answer:

To change column A to Title Case, select cell B2. Type =PROPER(A2), and press Enter. Tip: Use the formula =UPPER(A1) for all UPPERCASE; =LOWER(A1) for all lowercase.

Step-by-step explanation:

User Nalin Dobhal
by
3.5k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

3.5m questions

4.5m answers

Other Questions

Assume you have created a mechanical arm that can hold a pen. The arm can perform the following tasks: • Lower the pen to a piece of paper. • Raise the pen from the paper. • Move the pen 1 inch along a
What problem does chlorofluorocarbon (CFC) create? a. it causes lead poisoning b.it causes great damage to the ozone layer c. it leaks into food as it cools the air and refrigerators d. it is responsible
Does anyone have game design in connections
What do customers typically notice during virtual interactions?
Bob is stationed as a spy in Cyberia for a week and wants to prove that he is alive every day of this week and has not been captured. He has chosen a secret random number, x, which he memorized and told
Link Copied!