Using the Text Formula
And if i wish to put other information in column B will that information be
affected by the formula
"Paul B" wrote:
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?
|