View Single Post
 
Old 07-10-2012, 09:43 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote