change font from all capitals?
 

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.

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.

change font from all capitals?
 

Uset the formula
=Lower(A1)

--
HTH...

Jim Thomlinson


"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.

change font from all capitals?
 

Sub ChangeToLowerCae()
Dim lCap As Long


For lCap = 65 To 90
ActiveSheet.UsedRange.Replace Chr(lCap), LCase(lCap)
Next lCap
End Sub



--
Regards
Dave Hawley
www.ozgrid.com
"jumbiegirl" wrote in message
...
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.