Louise

After entering the formulas and returning the text in the format you want, copy
those cells and paste specialvalues(in place).

You can now delete the original cells.


Gord Dibben MS Excel MVP

On Fri, 31 Mar 2006 05:10:02 -0800, Louise
wrote:

Hi, thanks for your post.
this is the one i've tried before but you have to keep the text in the
original cells too, don't you?
Louise

"Maxwell" wrote:

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