changing text case

Copper Contributor

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.

3 Replies
It should be: =Lower(B1)
you mean =LOWER(B1)