Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to Convert uppercase to lowercase in excel?

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 29-04-2009
Member
 
Join Date: Jan 2009
Posts: 44
How to Convert uppercase to lowercase in excel?
  

Hi,
I have one excel document with all letters in capital. I want to convert it to lowercase. Can anyone help?

Thank you in advance.

Reply With Quote
  #2  
Old 29-04-2009
Member
 
Join Date: Apr 2008
Posts: 4,641
Re: How to Convert uppercase to lowercase in excel?

Use the LOWER function to convert all uppercase letters in a text string to lowercase.
The LOWER function is in the Text category in the Insert Function dialog box.

Example:
Text in uppercase: GEORGE W. BUSH
The function: =LOWER(A1)
Result: george w. bush
Reply With Quote
  #3  
Old 29-04-2009
Member
 
Join Date: Apr 2008
Posts: 4,086
Re: How to Convert uppercase to lowercase in excel?

Follow this Microsoft link: How to change the case of text in Excel
Reply With Quote
  #4  
Old 29-04-2009
Member
 
Join Date: May 2008
Posts: 4,339
Re: How to Convert uppercase to lowercase in excel?

To convert the uppercase to lowercase select a range of cells, then invoke 'Selected Area=>Convert=>Text Case to=>There you can convert text cases to proper case, upper case, or lower case.
You can also select a single cell in a table's column, invoke 'Column->Convert->Text Case to->...', this will convert the entire column's text cases to proper case, upper case, or lower case, and the converted values will be placed in a newly inserted column next to the original column.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Convert uppercase to lowercase in excel?"
Thread Thread Starter Forum Replies Last Post
What is uppercase and lowercase in computer? Akono Off Topic Chat 5 29-12-2011 10:31 PM
String to uppercase in java ISAIAH Software Development 5 24-02-2010 12:33 AM
Convert text to uppercase/lowercase using Macros Anas Windows Software 3 02-05-2009 02:23 PM
How to Convert uppercase characters into lowercase characters in C++ Japesh Software Development 3 25-10-2008 01:38 PM
Convert lowercase to uppercase ERWAN MS Office Support 1 09-10-2008 10:16 AM


All times are GMT +5.5. The time now is 12:12 AM.