How do you formatt text in Excel to be changed to UPPERCASE?

[Guest]

Hi

I know this can be done in MS word by highlighting the text and pressing
Shift+F3, however this shortcut does not work in Excel. Is there are way of
formatting a whole column/row to formatt the text already entered to change
to becoming all UPPERCASE?

Thanks for your help

 

[Guest]

You'll need an empty cell in which to enter the formula

=upper(cell with text)

then you copy the cell with the formula, select the cell with the text, and
select Edit>Paste Special>Values

 

[David McRitchie]

Since the change is wanted in place and permanent, it would be faster
to use a macro to save on all the clean up steps that would follow if you used a worksheet function.

http://www.mvps.org/dmcritchie/excel/proper.htm#upper

 

[Guest]

Thank you "Duke Carey" that is definetely the solution.