G Guest Dec 3, 2003 #1 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!
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!
D Don Guillett Dec 3, 2003 #2 a formula =lower(a1) =proper(a1) -- Don Guillett SalesAid Software (e-mail address removed) Chel said: Anyone know how to change the case (from all caps to lower case, or just Click to expand... first letter cap) without retyping all the text in a worksheet? Thanks!
a formula =lower(a1) =proper(a1) -- Don Guillett SalesAid Software (e-mail address removed) Chel said: Anyone know how to change the case (from all caps to lower case, or just Click to expand... first letter cap) without retyping all the text in a worksheet? Thanks!
C Chip Pearson Dec 3, 2003 #3 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 Click to expand... case, or just first letter cap) without retyping all the text in a worksheet? Thanks!
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 Click to expand... case, or just first letter cap) without retyping all the text in a worksheet? Thanks!
