The purpose of the Convert Text to columns wizard is to separate the content of one excel cell into separate cells. You can set the delimiters that your data contain and set the column data format.

In “Save time by using Excel’s Left ... then open the Data menu and choose Text To Columns. When you do, Excel launches the Convert Text To Columns Wizard. Make sure the Delimited radio ...

4 quick and easy ways to convert numbers stored as text to real numbers in Excel Your email has been ... You might use them all at some time or another. Check out this article I found on TechRepublic.