Applying function =lower(A1) on column and cell B1 does nothing. It justs prints as is and adds apostrophe before the function, '=lower(A1).
Followed this general advice for spreadsheets.
I just want to convert all the text in column A to lowercase.

