Hello Louise,
Try =LOWER(TEXT) converts all to lower case,
=UPPER(TEXT) convercts all to upper case,
=PROPER(TEXT) as near as possible it gives the text to you with the
Upper and Lower case text as MS sees it.

You just add you cell reference where I typed text.

Hope it helps.

Maxwell


"Bob Phillips" wrote:

VBA?

Dim cell As Range
For Each cell In ActiveSheet.UsedRange
If Not cell.HasFormula Then
cell.Value = LCase(cell.Value)
End If
Next cell


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Louise" wrote in message
...
hi all

is there a quick and easy way of changing text in Excel from upper to
lower
case or visa versa? I believe there is some kind of formula you can
create?
Is this the only way it can be done? I want to completely replace the
worksheet I have in upper to lower case.

Thank you.

Louise