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

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

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Duke Carey" wrote in message ...
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

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