change font from all capitals?

J

jumbiegirl

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

Gord Dibben

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
 
O

ozgrid.com

Sub ChangeToLowerCae()
Dim lCap As Long


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Font Case in Excel-HELP!!!! 6
Change all text on Spread sheet 1
Capitals 3
Proper Case 14
Change default font color for a single spreadsheet? 10
Can you change current small text in a cell to CAPITALS? 3
Changing a whole spreadsheet to proper case 1
Change Capitals to Sentence Case 2

Top