Chel,
You can use a macro like the following:
Sub ConvertCase()
Dim Rng As Range
For Each Rng In ActiveSheet.UsedRange.SpecialCells _
(xlCellTypeConstants, xlTextValues)
Rng.Value = StrConv(Rng.Text, vbProperCase) 'or vbLowerCase
or vbUpperCase
Next Rng
End Sub
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
Chel said:
Anyone know how to change the case (from all caps to lower
case, or just first letter cap) without retyping all the text in
a worksheet? Thanks!
