Open Excel and add a new column to the left of the data range you want to convert to a single column. Do this by selecting the far left column, clicking on it and then clicking "Insert" in the ...

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