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

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)

"dave01968" <dave01968@discussions.microsoft.com> wrote in message
news:CC42D7E4-E043-4CF3-8492-8967EFFE94C1@microsoft.com...
> How can I change the text from lower case to upper case in an Excel work
book
> and vice versa?

The lower case equivalents are LOWER and LCase.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dave01968" <dave01968@discussions.microsoft.com> wrote in message
news:CC42D7E4-E043-4CF3-8492-8967EFFE94C1@microsoft.com...
> How can I change the text from lower case to upper case in an Excel work
book
> and vice versa?