change font from all capitals?
See help on LOWER Function.
Or maybe PROPER function.
Using functions you will need helper cells.
If you want a macro to change all in place use this one.
Sub Lower()
Dim Cell As Range
Application.ScreenUpdating = False
For Each Cell In Selection
Cell.Formula = LCase(Cell.Formula)
Next
Application.ScreenUpdating = True
End Sub
Gord Dibben MS Excel MVP
On Mon, 26 Apr 2010 14:48:01 -0700, jumbiegirl
wrote:
I have a spreadsheet from someone and it's all in CAPS. i want to change all
the font to lower case. Is there a way.
|