How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

I am taking an Exel coarse and I Cannot change a range of cells

Customer Question

I am taking an Exel coarse and I Cannot change a range of cells from uppercase to lowercase from the formula bar can you help me?
Submitted: 5 years ago.
Category: Microsoft Office
Expert:  Chris L. replied 5 years ago.
Hello and thank you for using Just Answer.

I created you a file so you can see first hand. You can download it here:
http://wikisend.com/download/347482/Book1.xlsx

Say you have a bunch of uppercase things in row A
ABC
EFG
HIJ

In row B click on B1 in the formula bar type =LOWER(A1) and then drag over the cells to match Row A.

Here is a more detailed tutorial from microsoft:
http://support.microsoft.com/kb/263580

If you need further help please let me know.

Thank You
Expert:  John D replied 5 years ago.

Hi,

 

If you are looking for a macro script to automate this process here is a sample file with two macros - one to convert the selected range to Upper and the other to Lower

(If however you are not looking for a macro solution then ignore this answer and consider accepting the formula solution given by seashore above)

 

 

Attachment: 2012-03-07_172449_change_case.xls

 

Just select the range that you would like to change the case of and click one of the buttons

 

Make sure that on your system macros are enabled for the code to work

 

 

Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution

 

Customer: replied 5 years ago.
Thanks I am not sure if it will help but I will let you know as soon as i can .

Attachments are only available to registered users.

Register Here
Expert:  John D replied 5 years ago.

Ok here is a sample file

 

Attachment: 2012-03-07_201403_upper_lower.xls

 

The formulas are in the yellow cells. Try typing data in column A and see how the case changes in column B and C

 

Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution

 

Related Microsoft Office Questions