change lower letters to upper letters
 

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

change lower letters to upper letters
 

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

"Winnie" wrote in message
...
In the Excel, how to change all sentense from lower letters to upper
letter

change lower letters to upper letters
 

=UPPER(range)
--
Brevity is the soul of wit.


"Winnie" wrote:

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