| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 56739 | 2005-04-14 00:28:00 | Excel 2003-Changing fonts to upper case | ronmar (3384) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 344652 | 2005-04-14 00:28:00 | 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 |
ronmar (3384) | ||
| 344653 | 2005-04-14 00:37:00 | Does =UPPER help? | sal (67) | ||
| 344654 | 2005-04-14 02:24:00 | 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. |
ronmar (3384) | ||
| 344655 | 2005-04-14 03:35:00 | You need to resort to vB code for this, there is no native function in Excel to mass convert. Look here www.cpearson.com |
godfather (25) | ||
| 344656 | 2005-04-14 04:35:00 | You need to resort to vB code for this, there is no native function in Excel to mass convert. Look here www.cpearson.com 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. |
Parry (5696) | ||
| 344657 | 2005-04-14 04:36:00 | you could always use the =upper() function and then copy, paste special, paste values method | kiwipole (2469) | ||
| 344658 | 2005-04-14 08:35:00 | 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. |
craigb (4884) | ||
| 1 | |||||