Results 1 to 4 of 4

Thread: Changing lower case to upper case letters

  1. #1
    Neophyte hawkeye's Avatar
    Join Date
    Sep 2019
    Posts
    2
    Articles
    0
    Excel Version
    Microsoft 365

    Changing lower case to upper case letters



    Register for a FREE account, and/
    or Log in to avoid these ads!

    My wife has a spreadsheet that is all in lower case. She would like to change the people's names to all uppercase. Is this possible?
    Thanks in advance. We are on Windows 10 if that matters

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    193
    Articles
    0
    Excel Version
    2019
    Here is a VBA solution

    Code:
    Option Explicit
    
    
    Sub UpperCase()
        Dim c As Range, rng As Range
        Set rng = Range("A1:I9")  'change this to your range
        For Each c In rng
            c.Value = UCase(c)
        Next c
    End Sub


    Standard Module
    How to install your new code
    Copy the Excel VBA code
    Select the workbook in which you want to store the Excel VBA code
    Press Alt+F11 to open the Visual Basic Editor
    Choose Insert > Module
    Edit > Paste the macro into the module that appeared
    Close the VBEditor
    Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)


    To run the Excel VBA code:
    Press Alt-F8 to open the macro list
    Select a macro in the list
    Click the Run button

  3. #3
    Neophyte hawkeye's Avatar
    Join Date
    Sep 2019
    Posts
    2
    Articles
    0
    Excel Version
    Microsoft 365
    Thank You!

  4. #4
    Acolyte caabyyc's Avatar
    Join Date
    Dec 2014
    Location
    Burnaby/Calgary
    Posts
    29
    Articles
    0
    Excel Version
    2016
    b1=upper(a1)

Posting Permissions

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