I have 7000 addresses in my excel database, approximately 5000 are uppercase
text! I need to change them to lower case? is there a quick way without me
having to edit them all individually? Thanks
"Harald Staff" wrote in message
...
If you have this in cell A1:
THIS IS MY TEXT
then enter this in cell B1:
=LOWER(A1)
and B1 will display
this is my text

If this is not what you want then please be more specific.

HTH. Best wishes Harald

"kez" skrev i melding
...
Please could you tell me how to do this? Thanks
"Harald Staff" wrote in message
...
You need a small macro, or a formula in another cell, like
=LOWER(A1)

HTH. Best wishes Harald

"kez" skrev i melding
...
How do I format LARGE CASE text to small case in excel 2002. Thanks
Keith