![]() |
|
|
|
#1
|
||||
|
||||
|
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] |
|
| Tags |
| import from text |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How to import multiple text file data into word
|
mizankabir | Word VBA | 7 | 09-15-2023 10:27 PM |
macro, data import from the ONLY text file in current folder
|
ue418 | Excel Programming | 5 | 10-28-2017 12:52 PM |
Run-time error '91': Object variable or With block variable not set
|
tinfanide | Excel Programming | 2 | 06-10-2012 10:17 AM |
| Import formatted text from Word into PowerPoint | parboy | PowerPoint | 0 | 07-06-2011 08:52 AM |
Import Text from File - Line Spacing
|
marshalx | Word | 2 | 10-28-2009 02:37 AM |