Is there a way in Excel 2000 to find the cells that contain all CAPS? I have a client with a large mailing list and I want to filter out only the ones in CAPS.
Thank you,
Dawn
Thank you,
Dawn
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Find cells with all caps
- Thread starter dawnd3
- Start date
Dunno if it's possible in standard formulae - this UDF will put a marker of TRUE or FALSE as to whether a cell content is ALL Caps or not tho
Function Caps(rng As Range) As Boolean
Application.Volatile
For i = 1 To Len(rng.Text)
Select Case Mid(rng.Text, i, 1)
Case Chr(65) To Chr(90)
Caps = True
Case Else
Caps = False
Exit For
End Select
Next i
End Function
Rgds
Geoff
Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur
Function Caps(rng As Range) As Boolean
Application.Volatile
For i = 1 To Len(rng.Text)
Select Case Mid(rng.Text, i, 1)
Case Chr(65) To Chr(90)
Caps = True
Case Else
Caps = False
Exit For
End Select
Next i
End Function
Rgds
Geoff
Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur
- Status
Similar threads
- Locked
- Question
