changing text case in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am looking for a way to convert text in an excel
worksheet from UPPERCASE to lowercase. I tried the helpful
hint provided in software, but I couldn't get it to work
 
Hi
one way if your text is in column A: Use the following formula in B1
=LOWER(A1)
and copy down. After this you may copy this range and insert it again
with 'Edit - Paste Special - Values'
 
Not sure if this is what you want, but the function LOWER() handles cas
conversion.

=LOWER(A1) will convert A1 to lower case.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing from lower case to upper case 11
Excel Excel Conditional Format 2
Lowercase text changed by Ecel to Uppercase after import 5
uppercase to lowercase 4
Counting Characters in cells 9
how do i change the words from lower case to uppercase/capitals 3
automatically changing text case 4
Changing uppercase to lowercase 4

Back
Top