capnhud, with the text you want to change in column A, in B1 put =LOWER(A1)
and copy down

--
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

"capnhud" wrote in message
...
I have a range of cells that I want to apply the =LOWER function to but
each
time that I go to make the text lowercase the text disappears from the
cell.
I was wondering if someone could tell me what I was possibly doing wrong?