Hi Louise

I use ASAP Utilities' add-in. It does this and much more! It's available
from he
www.asap-utilities.com

Hope this helps.
Andy.

"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