• Change Case (Excel XP)

    Author
    Topic
    #409133

    I know word has a change case feature….and I know excel does to but I cannot get the change case feature in excel to work…HELP!

    Viewing 1 reply thread
    Author
    Replies
    • #869642

      To change case in Excel you can use one of 3 functions
      Change text to upper case
      =UPPER(A1)
      Change text to lower case
      =LOWER(A1)
      Change text to proper (or title) case
      =PROPER(A1)

      You can also use VBA to change case, for details see changing text case by Chip Pearson

    • #869643

      To change case in Excel you can use one of 3 functions
      Change text to upper case
      =UPPER(A1)
      Change text to lower case
      =LOWER(A1)
      Change text to proper (or title) case
      =PROPER(A1)

      You can also use VBA to change case, for details see changing text case by Chip Pearson

    Viewing 1 reply thread
    Reply To: Change Case (Excel XP)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: