How To Convert All Text To Lowercase In Google Spreadsheets

1. Select the column, right-click, and click Insert Column Right.
2. In the first cell of the new column enter formula =LOWER(A1) (or whatever the first cell is of the original column).
3. Copy the cell with the formula in it.
4. Select the column and paste - Google Spreadsheets is smart enough to adjust the row number for each pasted entry. You now have a column with lowercase in it - but it requires that column to the left to still be there.
5. Select the new column again and copy.
6. Right-click and click Paste Special > Values only.

This wipes out the formulas. You can now delete the original column. Yay hacks. Obviously this applies to anything you could do with a formula in spreadsheets.