Excel doesn't offer a one-click solution if you need text in sentence case (where only the first letter of the sentence is capitalized). But don’t worry! You can create a custom formula using the LEFT ...

How to Convert Excel to Text & Set Column Width. ... Excel's myriad formatting tools let you add colors, formulas and borders almost anywhere in a worksheet. You can also c.

Type the formula =Value() and inside the parentheses, type a cell reference that contains text stored as numbers. In this example, it’s cell A2 . Press Enter.