+ Reply to Thread
Results 1 to 4 of 4

How do I change a column in Excel from upper case to lower case?

  1. #1
    Debbie Kennedy
    Guest

    How do I change a column in Excel from upper case to lower case?

    How do I change a column in Excel from upper case to lower case?

  2. #2
    Max
    Guest

    Re: How do I change a column in Excel from upper case to lower case?

    Assume data in col A, A1 down
    Put in B1: =LOWER(A1)
    Copy down

    Copy col B, then overwrite col A with a paste special > values
    Delete col B
    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1 22' N 103 45' E
    xdemechanik <at>yahoo<dot>com
    ----
    "Debbie Kennedy" <Debbie Kennedy@discussions.microsoft.com> wrote in message
    news:DB88FB11-8EAF-4609-A654-77AAB54E27D3@microsoft.com...
    > How do I change a column in Excel from upper case to lower case?




  3. #3
    Alan
    Guest

    Re: How do I change a column in Excel from upper case to lower case?

    If your upper case data were in A1 to A whatever, in B1
    =LOWER(A1)
    drag B1 down as necessary to the end of your range in coulumn A
    see also
    =UPPER(A1) and
    =PROPER(A1)
    Regards,
    "Debbie Kennedy" <Debbie Kennedy@discussions.microsoft.com> wrote in message
    news:DB88FB11-8EAF-4609-A654-77AAB54E27D3@microsoft.com...
    > How do I change a column in Excel from upper case to lower case?




  4. #4
    JE McGimpsey
    Guest

    Re: How do I change a column in Excel from upper case to lower case?

    Try David McRitchie's "Lower_Case" macro:

    http://www.mvps.org/dmcritchie/excel/proper.htm#lower

    In article <DB88FB11-8EAF-4609-A654-77AAB54E27D3@microsoft.com>,
    "Debbie Kennedy" <Debbie Kennedy@discussions.microsoft.com> wrote:

    > How do I change a column in Excel from upper case to lower case?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1