Take off CAPS on an entire spreadsheet
 

I have a spreadsheet that has names entered in CAPS. How do i take the CAPS
off the whole spreadsheet?

Take off CAPS on an entire spreadsheet
 

You can add a column next to the columns with the caps and use
=Proper(A1) for instance to change to proper case for the entry in
A1. I don't know of a way to change a whole spreadsheet in one
command.

Take off CAPS on an entire spreadsheet
 

Run this small macro:

Sub decapitate()
For Each r In ActiveSheet.UsedRange
v = r.Value
If IsEmpty(v) Or Not Application.WorksheetFunction.IsText(v) Then
Else
r.Value = LCase(r.Value)
End If
Next
End Sub

--
Gary''s Student - gsnu200765


"Martha" wrote:

I have a spreadsheet that has names entered in CAPS. How do i take the CAPS
off the whole spreadsheet?