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.