Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conversion of lower case characters to uppercase (2003)

    Is there a way to convert lower case characters to upper case characters?
    Any help would be appreciated.

  2. #2
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conversion of lower case characters to upperca

    =UPPER("lowercase") will result in "LOWERCASE"

    Cheers
    Peter

  3. #3
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conversion of lower case characters to upperca

    That

  4. #4
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Ross-on-Wye, Herefordshire, United Kingdom
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conversion of lower case characters to upperca

    The attached worksheet example should help? Column D in Yellow shows how to convert to upper case the values in column A. Column F in blue shows how to use the UPPER function within a formula.

    You need to decide what it is you are trying to do with the data in order to decide how best to handle it? If this is a one time excercise you can just use a brute force method like Column D in the attached:

    Find an empty column somewhere
    Insert the formula =UPPER(A2) in XXX2 - Where XXX is the empty column you are using
    Copy and paste the formula in XXX2 all the way down to XXX9999 - Where 9999 mathces the last row that has data in Column A
    Highlight and copy the RANGE XXX2 : XXX9999
    Position the cursor in A2
    On the Excel Menu, click Edit, Paste Special. Click on Values and then click OK
    The data in A2:A9999 wil be replaced by the UPPER case data you created in column XXX
    You can delete the entries in column XXX if you want to

    The above is fine if you are only ever going to do this once.. If this data is going to be re-entered, re-imported, sent to you frequently, your BEST option is to ask for the data in the format you need it. If you can't do that, you can either use the above technique to re-create the data in Column A in another column (Column F in my example) and refer to your new column in any calculations/lookups etc. Failiing that, create a copy sheet as shown in the attached worksheet (I've called the sheet Copy, use a more meaningful name!) - Look at the formulas cells A2:A20 and B2:B20.

    Hope the above helps. Good luck!

    Cheers
    Peter

  5. #5
    4 Star Lounger
    Join Date
    Jul 2006
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conversion of lower case characters to upperca

    That

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •