+ Reply to Thread
Results 1 to 4 of 4

change lower-case to upper-case

  1. #1
    Registered User
    Join Date
    03-11-2006
    Posts
    8

    change lower-case to upper-case

    I input lower-case in the cell and how to return the upper-case.
    e.g. I input aaa in the cell and return the AAA
    It is not the function upper( ).

  2. #2
    Bernard Liengme
    Guest

    Re: change lower-case to upper-case

    If A1 has the aaa then B1 could have =UPPER(A1) to get uppercase text
    But you cannot change the value in the cell A1 with a formula.

    If you are doing this to a column of data, you could copy B column and then
    use Edit|Paste Special -> Values to replace B's formulas by text and then
    delete column A.

    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "cutyfurby" <cutyfurby.27yhkc_1147876509.9121@excelforum-nospam.com> wrote
    in message news:cutyfurby.27yhkc_1147876509.9121@excelforum-nospam.com...
    >
    > I input lower-case in the cell and how to return the upper-case.
    > e.g. I input aaa in the cell and return the AAA
    > It is not the function upper( ).
    >
    >
    > --
    > cutyfurby
    > ------------------------------------------------------------------------
    > cutyfurby's Profile:
    > http://www.excelforum.com/member.php...o&userid=32371
    > View this thread: http://www.excelforum.com/showthread...hreadid=542928
    >




  3. #3
    aidan.heritage@virgin.net
    Guest

    Re: change lower-case to upper-case

    As it IS the function Upper I don't understand the question!


  4. #4
    Gary
    Guest

    Re: change lower-case to upper-case

    use ASAP utilities...its an ADD IN.

    "cutyfurby" <cutyfurby.27yhkc_1147876509.9121@excelforum-nospam.com> wrote
    in message news:cutyfurby.27yhkc_1147876509.9121@excelforum-nospam.com...
    >
    > I input lower-case in the cell and how to return the upper-case.
    > e.g. I input aaa in the cell and return the AAA
    > It is not the function upper( ).
    >
    >
    > --
    > cutyfurby
    > ------------------------------------------------------------------------
    > cutyfurby's Profile:
    > http://www.excelforum.com/member.php...o&userid=32371
    > View this thread: http://www.excelforum.com/showthread...hreadid=542928
    >




+ 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