vms, to use the lower function you would reference the cell with the text
you want to change so if the text is in column A you would put =LOWER(A1) in
a empty column and copy it down to the last row that you want to change, to
copy it down click your mouse on the little black box in the bottom right
hand corner of the cell and drag it down, you will then have the data
changed to lower case, highlight the lower case data, right click and copy
then select A1, in this example and right click and paste special, valves,
now your data should be lower case, delete the data with the lower formula
in it, if you need more help post back with how you date is in the sheet and
what you want to change
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"vms" wrote in message
...
I get some error about circular reference. I'm such a novice, I may need
more detailed instructions. Thanks.

"Paul B" wrote:

VMS, you can put something like =LOWER(A1) in another column and copy
down,
then paste back over your data or use a macro like this

Sub Make_Lower_Case()
'select range and run this to change to all lower case
Dim cel As Range
Application.ScreenUpdating = False
For Each cel In Intersect(Selection, _
ActiveSheet.UsedRange)
cel.Formula = LCase$(cel.Formula)
Next
Application.ScreenUpdating = True
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"vms" wrote in message
...
Can you make ALL CAPS text change to lower case automatically, without
re-typing?
--
"You can have everything in life you want, if you will just help enough
other people get what they want." -- Zig Ziglar