Excel lowercase everything?

Question

Is there an Excel code to make everything lowercase? I don't need "Proper," (upper and lower case), just lowercase.

Answer 1

lcase is the function to lowercase something.

To make everything lower case in cell A1 it would be

let cells(1,1) = lcase(cells1,1)

that is the VB code for it

Answer 2

there's no built-in way to just tell excel to convert everything to lower case.  What you would need to do is apply the LOWER() formula to every cell that you want to convert.

for example LOWER(A1) will convert the contents of A1 to lower case.

you could then copy > paste special and select values and paste the values of that formula back on top of your original data.