Changing case

[Peter Downes]

Is there an easy way to change the case of a block of cells containing data
from lower case to upper case?

 

[Barb Reinhardt]

If you want to change the case of cell A1 to uppercase, use the following
equation:

=upper(A1)

 

[olasa]

A1: abc
B1: =UPPER(A1) ---> ABC
C1: =PROPER(A1) ---> Abc

HTH
Ola

 

[Paul B]

Peter, if you want to do it all at one time here is one way with a macro

Sub Make_CAPS()
'select range and run this to change to all CAPS
Dim cel As Range
Application.ScreenUpdating = False
For Each cel In Intersect(Selection, _
ActiveSheet.UsedRange)
cel.Formula = UCase$(cel.Formula)
Next
Application.ScreenUpdating = True
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