Results 1 to 7 of 7
  1. #1
    Junior Member
    Join Date
    Dec 2004
    Posts
    13

    Cool Excel 2003-Changing fonts to upper case

    Could you help with the following problem please, it is How do you change fonts to upper case in multiple cells using Excel 2003?
    Thank you

  2. #2
    Senior Member
    Join Date
    Dec 2004
    Location
    New Zealand
    Posts
    1,425

    Default Re: Excel 2003-Changing fonts to upper case

    Does =UPPER help?

  3. #3
    Junior Member
    Join Date
    Dec 2004
    Posts
    13

    Cool Re: Excel 2003-Changing fonts to upper case

    If you use just "=upper" then it does not work. If you then use say"=upper(a2) it the produces the contents of cell a2 in the cell you are using. If you go to the cell that you want to change to upper case and the enter "=upper" it indicates you are entering a circular reference.

    What I am looking for is the ability to highlight numerous cells containing text in an excel spread sheet and convert all of the letters into upper case.

    Thank you so far.

  4. #4
    Senior Member godfather's Avatar
    Join Date
    Dec 2004
    Location
    Central New Munster
    Posts
    3,053

    Default Re: Excel 2003-Changing fonts to upper case

    You need to resort to vB code for this, there is no native function in Excel to mass convert.

    Look here
    http://www.cpearson.com/excel/case.htm

  5. #5
    Senior Member
    Join Date
    Dec 2004
    Location
    Wellington, NZ
    Posts
    353

    Default Re: Excel 2003-Changing fonts to upper case

    Quote Originally Posted by godfather
    You need to resort to vB code for this, there is no native function in Excel to mass convert.

    Look here
    http://www.cpearson.com/excel/case.htm
    Yup GF is correct, VB is the only way to affect the environment directly. However, a non-code approach is the following 4 step process...

    1) In a blank column enter the formula =UPPER(A2) etc where A2 is the cell you want to convert to upper case. Fill down the formula however many rows you require.
    2) Copy the range that holds the formulas.
    3) Select the range you want to covert to upper case and select Edit|Paste Special and choose the values option.
    4) Delete the column with the formulas.

  6. #6
    Junior Member
    Join Date
    Apr 2005
    Posts
    2

    Default Re: Excel 2003-Changing fonts to upper case

    you could always use the =upper() function and then copy, paste special, paste values method

  7. #7
    Member
    Join Date
    Dec 2004
    Location
    Wainuiomata
    Posts
    73

    Default Re: Excel 2003-Changing fonts to upper case

    I had to do some reformatting of text in Excel once, but excel doesen't have the same abilities as Word to refomat bulk text. Solution - Copy/paste the spreadsheet into word, reformat text, and copy/paste the result back into excel. Worked for me but it was a simple spreadsheet so it wasn't too dificult. Hope this helps.

    edit

    May be a different story if you want the result in a cell to be from a formulas which I think you do from re-reading your post. Oh well nice try.
    Last edited by craigb; 14-04-2005 at 07:37 PM.

Similar Threads

  1. Excel Formula - Detecting or Changing Case
    By GrahamB in forum PressF1
    Replies: 4
    Last Post: 01-01-2008, 10:02 PM
  2. Outlook 2003 Fonts
    By bruciebear in forum PressF1
    Replies: 1
    Last Post: 13-07-2006, 12:58 PM
  3. Upper case listings with ME
    By Mzee in forum PressF1
    Replies: 1
    Last Post: 07-10-2004, 01:15 PM
  4. ME tends to save in upper case.
    By Mzee in forum PressF1
    Replies: 3
    Last Post: 26-09-2003, 12:42 AM
  5. Random text case changing
    By Mzee in forum PressF1
    Replies: 6
    Last Post: 03-07-2002, 10:53 PM

Posting Permissions

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