![]() |
|
#2
|
||||
|
||||
|
Perhaps save it in a text file then import in XL, using the ; as delimiter.You now have all data in one row in separate cells
Now Copy the row - Paste Special - Tranpose and everything should be in one column
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Text in string
|
projectpupil7 | Excel | 7 | 11-23-2014 12:03 AM |
Split file using variable delimiter
|
kramer74 | Word VBA | 7 | 09-01-2014 12:12 AM |
Way to search for a string in text file, pull out everything until another string?
|
omahadivision | Excel Programming | 12 | 11-23-2013 12:10 PM |
Find and replace a string of text
|
errtu | Word | 1 | 01-31-2013 02:09 PM |
| Renaming Word Formfields: string too long error | silverspr | Word VBA | 7 | 01-22-2013 06:20 PM |