Change the text from lower case to upper case in an Excel work boo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I change the text from lower case to upper case in an Excel work book
and vice versa?
 
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)
 
The lower case equivalents are LOWER and LCase.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Back
Top