| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the font to all caps for the entire worksheet? | Excel Worksheet Functions | |||
| How can I make my entire document CAPS? | Excel Worksheet Functions | |||
| How do convert an entire column of text in Excel to all caps? | Excel Discussion (Misc queries) | |||
| How do I make all caps in a column of any spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I change a spreadsheet from all caps to "Proper" | Excel Discussion (Misc queries) | |||
Hybrid Mode
