The text string also works in ZIP files, HTML files, and URLs. Microsoft is investigating the issue, but there’s no telling if or when a fix could show up. As a company spokesperson told The Verge: ...

=REPLACE(LOWER(C2),1,1,UPPER(LEFT(C2,1))) Press Enter. The above formula will capitalize the first letter of the text string which is in cell C2 and convert the rest into lowercase. Here’s how ...

Just copy and paste it into your spreadsheet, and it will work as long as the formula correctly references the cell that contains the text string you want converted to sentence case (T3 in the example ...