Results 1 to 4 of 4

Thread: How to Convert uppercase to lowercase in excel?

  1. #1
    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.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,642

    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

  3. #3
    Join Date
    Apr 2008
    Posts
    4,088

    Re: How to Convert uppercase to lowercase in excel?

    Follow this Microsoft link: How to change the case of text in Excel

  4. #4
    Join Date
    May 2008
    Posts
    4,345

    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.

Similar Threads

  1. What is uppercase and lowercase in computer?
    By Akono in forum Off Topic Chat
    Replies: 5
    Last Post: 29-12-2011, 10:31 PM
  2. String to uppercase in java
    By ISAIAH in forum Software Development
    Replies: 5
    Last Post: 24-02-2010, 12:33 AM
  3. Convert text to uppercase/lowercase using Macros
    By Anas in forum Windows Software
    Replies: 3
    Last Post: 02-05-2009, 02:23 PM
  4. Replies: 3
    Last Post: 25-10-2008, 01:38 PM
  5. Convert lowercase to uppercase
    By ERWAN in forum MS Office Support
    Replies: 1
    Last Post: 09-10-2008, 10:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,419,270.42495 seconds with 17 queries