If the information in the second column is always a five-digit number, try a regular expression (wildcard) find/replace to replace the spaces either side the number with tabs. If it's only for import (so, not to look pretty) you don't even need to set the tab positions.

Note: you can already take a look a this, by exploring the Use wildcards option and the [Special] button in the Find and Replace dialogue – but someone else will need to pick up this thread and explain how to say "replace a space, five digits, and a space by a tab, the same five digits, and a tab". [I can only see "replace with Find what", which means the spaces are still there after adding the tabs]

Depending on what tools you feel comfortable with, you might be able to do this faster in a good text editor.