Tools / Lists and text
Text case converter
For product names, headings and columns that came out of a system in capitals.
- Lines
- 2
- Characters
- 61
Title Case
Do it in a spreadsheet
A2text
How it works
In a sheet, =UPPER(A2), =LOWER(A2) and =PROPER(A2) do the first three. PROPER capitalizes after every space and after characters such as apostrophes, so check names like O'Brien. There is no built-in sentence case function.