+ Reply to Thread
Results 1 to 4 of 4

Convert lower case charecters to upper case

Hybrid View

Guest Convert lower case charecters... 09-10-2005, 06:05 AM
Guest Re: Convert lower case... 09-10-2005, 08:05 AM
Guest Re: Convert lower case... 09-10-2005, 08:05 AM
Guest Re: Convert lower case... 09-10-2005, 08:05 AM
  1. #1
    Dinesh
    Guest

    Convert lower case charecters to upper case

    Is there a way that we can convert lower case charecters to upper case in MS
    Excel cells? I have more than 150 User ID's written down in Excel using both
    Upper case and Lower case. But now I need to convert them in to upper case.
    Is there an option for that?

  2. #2
    Paul B
    Guest

    Re: Convert lower case charecters to upper case

    Dinesh, there is an upper function, you could put this in a nother column
    and copy down, =UPPER(A1) , then paste special back over the data or you
    could use a macro like this and do it all at once

    Sub Change_To_Uppercase()
    'select range and run this to change to all CAPS
    Dim cel As Range
    For Each cel In Intersect(Selection, _
    ActiveSheet.UsedRange)
    cel.Formula = UCase$(cel.Formula)
    Next
    End Sub


    --
    Paul B
    Always backup your data before trying something new
    Please post any response to the newsgroups so others can benefit from it
    Feedback on answers is always appreciated!
    Using Excel 2002 & 2003

    "Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
    news:A1B74575-CDE7-4450-9802-6DF04A1E0E93@microsoft.com...
    > Is there a way that we can convert lower case charecters to upper case in

    MS
    > Excel cells? I have more than 150 User ID's written down in Excel using

    both
    > Upper case and Lower case. But now I need to convert them in to upper

    case.
    > Is there an option for that?




  3. #3
    Dave Peterson
    Guest

    Re: Convert lower case charecters to upper case

    You can use a helper column of cells.

    Say your data is in A1:A150,
    put this in B1
    =upper(a1)
    and drag down.

    You could select column B
    Edit|copy
    edit|Paste special|values
    and delete column A if you wanted.

    Dinesh wrote:
    >
    > Is there a way that we can convert lower case charecters to upper case in MS
    > Excel cells? I have more than 150 User ID's written down in Excel using both
    > Upper case and Lower case. But now I need to convert them in to upper case.
    > Is there an option for that?


    --

    Dave Peterson

  4. #4
    Ian
    Guest

    Re: Convert lower case charecters to upper case

    Assuming your original IDs are in column 1. Use a helper column eg
    =UPPER(A1), then copy down. You can then copy and Paste Special>Values to
    overwrite the original data.

    --
    Ian
    --
    "Dinesh" <Dinesh@discussions.microsoft.com> wrote in message
    news:A1B74575-CDE7-4450-9802-6DF04A1E0E93@microsoft.com...
    > Is there a way that we can convert lower case charecters to upper case in
    > MS
    > Excel cells? I have more than 150 User ID's written down in Excel using
    > both
    > Upper case and Lower case. But now I need to convert them in to upper
    > case.
    > Is there an option for that?




+ 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