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

"Duke Carey" wrote:

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 EditPaste SpecialValues



"Chopper_Haynes" wrote:

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