Enter the formula in adjacent empty cell.
You're probably trying to do it in the same cell as the source text.
For example, assuming the source range is in A1 down
Enter in B1: =LOWER(A1)
Copy B1 down
Col B will return the required results
If needed, we could copy col B
and do a paste special check "values" ok
to overwrite col A. And then delete col B
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"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?