How do you make all letters capitals in an existing spread sheet
Thanks

You would need a macro for that to be simple


Sub Upper_Case()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim Cell as Range
On Error Resume Next
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
Cell.Formula = UCase(Cell.Formula)
Next
Application.Calculation = xlCalculationAutomatic
Application.ScreenUpdating = True
End Sub

there is also a function called UPPER that will convert all letters to upper
case

to install macros see

http://www.mvps.org/dmcritchie/excel/install.htm

--


Regards,


Peo Sjoblom

"hollis" wrote in message
...
How do you make all letters capitals in an existing spread sheet
Thanks