G Guest Dec 9, 2005 #1 How can I change the text from lower case to upper case in an Excel work book and vice versa?
B Bob Phillips Dec 9, 2005 #2 To get the value in an other cell =UPPER(A1) If you want to do a whole sheet, with VBA For each cell In Activesheet.UsedRange If Not cell.HasFormula Then cell.Value = UCase(Cell.Value) End If Next cell -- HTH Bob Phillips (remove nothere from email address if mailing direct)
To get the value in an other cell =UPPER(A1) If you want to do a whole sheet, with VBA For each cell In Activesheet.UsedRange If Not cell.HasFormula Then cell.Value = UCase(Cell.Value) End If Next cell -- HTH Bob Phillips (remove nothere from email address if mailing direct)
B Bob Phillips Dec 9, 2005 #3 The lower case equivalents are LOWER and LCase. -- HTH Bob Phillips (remove nothere from email address if mailing direct)
The lower case equivalents are LOWER and LCase. -- HTH Bob Phillips (remove nothere from email address if mailing direct)