How to separate text from one column of Excel

If you have text such as addresses or first and last names in one column of Excel 2007 and you want each piece of text to be in its own column, here's what you do.

1) Let's say we want the first name, middle initial, and last name to be in their own column.



















2) Select the text and then go to the Data tab. Click on the Text to Columns button and a "Wizard" window will open to guide you through the remaining steps. In this example, I checked the "Space" delimiter since the text is separated by spaces. "Delimiter" is the type character that is separating the text within the spreadsheet cell. This character could be a comma, a space, a tab, etc.



3) Here's the final result.