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 ...

Follow the steps below to convert text to columns in Excel: Launch Excel. Enter some data into a single cell, for example, the first name and last name of people.