Excel cannot tell which parts of your data are which. If you use spaces as the separators, each word necesarily goes into a new column. Since you apparently have numbers, then text, then more numbers, you could pre-process the data in Word, using Find/Replace to add tabs between the numbers and text. In Excel, you could then use the tabs as the separators.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|