Take off CAPS on an entire spreadsheet

M

Martha

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

HKaplan

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

Gary''s Student

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
 

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

change to all caps 4
Change all text on Spread sheet 1
change font from all capitals? 3
Change entire column in spreadsheet from upper case 1
How do I convert addresses to all caps in Office 2007? 3
Changing all caps to proper 7
Forcing All Caps in input cells 8
How do I change a spreadsheet from all caps to "Proper" 9

Top