Just make sure there are no formulas in the cells you select.

This code will change all to values only.


Gord Dibben MS Excel MVP

On Wed, 4 Nov 2009 10:25:28 -0800, Gary''s Student
wrote:

With text in A1:

=UPPER(A1) will display the text in all upper case

If you want to convert the text "in place", then try this simple macro:

Sub GoToUpper()
For Each r In Selection
r.Value = UCase(r.Value)
Next
End Sub

First select the cells and then run the macro.