Although this video is for Excel 2007 it is the same in Excel 2003 except for how you get to the “Text to Column” command.

The key to remember for this to work in the desired manner is that wherever you want Excel to “break” the data into separate cells must be “pre-defined” with some type of character. As you will see in the video it can be nearly anything (letters or spaces are probably not a good idea).

If you need any help with this please feel free to reach out to me on Twitter.