Forum Discussion
changing text case
I am trying to change upper and lower case letters to just lower case. I have done the text conversion but when I put the formula =b1(lower) in column C, I just get #REF! instead of the text being converted to all lower case.
- you mean =LOWER(B1)
- It should be: =Lower(B1)
