Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    Houston, Texas, USA
    Posts
    91
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good evening! I have an Excel file with a mixture of names in lowercase and uppercase. How do I change them all to uppercase without using two columns? Is
    there a way to change a group of highlighted cells from lowercase to uppercase in Excel, as you can do in Word?

    Regards,

    Dea Friloux

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could run a macro:

    Code:
    Sub Change2Upper()
      Dim oCell As Range
      For Each oCell In Selection
    	oCell = UCase(oCell)
      Next oCell
    End Sub

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    [quote name='dfriloux' post='795748' date='30-Sep-2009 22:48']Good evening! I have an Excel file with a mixture of names in lowercase and uppercase. How do I change them all to uppercase without using two columns? Is
    there a way to change a group of highlighted cells from lowercase to uppercase in Excel, as you can do in Word?

    Regards,

    Dea Friloux[/quote]

    If it's a one off exercise, I'd be tempted to copy and paste into Word, do the magic with Crtl+F3 and paste the upper case text back into the column.

    But I'm just lazy sometimes :-)

  4. #4
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    [quote name='dfriloux' post='795748' date='30-Sep-2009 22:48']Good evening! I have an Excel file with a mixture of names in lowercase and uppercase. How do I change them all to uppercase without using two columns?[/quote]

    If this is a one off exercise and you are prepared to use two columns temporarily then (assuming that original is in column A) you could
    • Put =upper(A1) into the first available cell in your temporary column
    • Drag this new cell down to fill however many rows are in the original column
    • Select all the new cells
    • Edit > Copy
    • Select cell A1
    • Edit > Paste Special > Values
    • Clear all the cells in the temporary column

Posting Permissions

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