change lower letters to upper letters

[Guest]

In the Excel, how to change all sentense from lower letters to upper letter

 

[Paul B]

Winnie, you can use the upper function, with text in column, in another
column put =UPPER(A1) and copy down, you can then copy that column and paste
special back over you data.

Or you could use a macro like this


Sub MAKE_ALL_CAPS()
'select your range and run this to change to all CAPS
Dim cel As Range
For Each cel In Intersect(Selection, _
ActiveSheet.UsedRange)
cel.Formula = UCase$(cel.Formula)
Next
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

In the Excel, how to change all sentense from lower letters to upper

letter

 

[Guest]

=UPPER(range)