Excel: swithing lower to upper case possible?

Discussion in 'Computer Support' started by Sigi Rindler, Nov 25, 2006.

  1. Sigi Rindler

    Sigi Rindler Guest

    I had to translate part lists in Excel (lower case letters). Now I was told
    to change them all to upper case letters. Where does Excel 2003 have this
    function?
    Right now I need to copy consecutive blocks of text into MS Word, change the
    case, then copy these files back into Excel...
    I hope that this is possible since I seem to get these kind of work
    continuously. Typing in upper case letters is no fun and it's hard to read.

    Thanks,
    Murgi



    ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
    http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
    ----= East and West-Coast Server Farms - Total Privacy via Encryption =----
     
    Sigi Rindler, Nov 25, 2006
    #1
    1. Advertising

  2. Sigi Rindler

    Gordon Guest

    Sigi Rindler wrote:
    > I had to translate part lists in Excel (lower case letters). Now I was told
    > to change them all to upper case letters. Where does Excel 2003 have this
    > function?


    UPPER function.....in Excel 2003
     
    Gordon, Nov 25, 2006
    #2
    1. Advertising

  3. Sigi Rindler

    SgtMinor Guest

    Sigi Rindler wrote:

    > I had to translate part lists in Excel (lower case letters). Now I was told
    > to change them all to upper case letters. Where does Excel 2003 have this
    > function?
    > Right now I need to copy consecutive blocks of text into MS Word, change the
    > case, then copy these files back into Excel...
    > I hope that this is possible since I seem to get these kind of work
    > continuously. Typing in upper case letters is no fun and it's hard to read.
    >
    > Thanks,
    > Murgi


    If the UPPER function does not work for you, you could import the
    entire spreadsheet into Word by first saving it as a .csv (comma
    separated value) file. Word will open the file, you convert all
    text to upper case, and save it as a .txt file. Manually change
    the extension back to .csv and Excel will open it. You'll need to
    do a little formatting after that.

    Excel will also open the file if you leave the extension as .txt
    but it's a lot more of a hassle.
     
    SgtMinor, Nov 26, 2006
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. JeanPaul Parly Beech

    UPPER CASE

    JeanPaul Parly Beech, Sep 25, 2003, in forum: Computer Support
    Replies:
    10
    Views:
    920
    JohnI in Brisbane
    Sep 26, 2003
  2. Ch. Rajinder Nijjhar Jatt

    Upper and Lower case letters

    Ch. Rajinder Nijjhar Jatt, Nov 2, 2003, in forum: Computer Support
    Replies:
    5
    Views:
    745
    slumpy
    Nov 2, 2003
  3. Andy

    UPPER CASE

    Andy, May 3, 2004, in forum: Computer Support
    Replies:
    16
    Views:
    13,601
    Allamosa
    May 10, 2004
  4. Ch. Rajinder Nijjhar Jatt

    Upper and lower case

    Ch. Rajinder Nijjhar Jatt, Dec 26, 2004, in forum: Computer Support
    Replies:
    6
    Views:
    559
    Ch. Rajinder Nijjhar Jatt
    Dec 26, 2004
  5. ropio

    Make parameter Upper case

    ropio, Jul 19, 2006, in forum: Software
    Replies:
    1
    Views:
    881
    fred5152
    Dec 18, 2007
Loading...

Share This Page