| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Condensing Imported fixed-width text with multiple data lines to one Excel row
I have a text file report with about 1,000 names listed as below. The
address is always one row down from name, the City-State-Zip is always 2 down from name, the DOB is 5 down. The email is always one column over and 5 rows down. Joe A Blow 555 LAREWOOD DRIVE Vass, NC 28215 DOB = 1960-07-27 email: My ideal end-product is to have each customer on one row with the following column headings: Name, Address, City-State-Zip, DOB, and email. Any ideas on how to get started? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Data from Excel to MS Outlook in Plain Text Mode | Excel Worksheet Functions | |||
| text box insert in Excel - text box lines print on second copy | Excel Discussion (Misc queries) | |||
| Formatting on imported data (Excel 2003) | Excel Discussion (Misc queries) | |||
| Sort order : Excel vs imported data | Excel Discussion (Misc queries) | |||
| Outside Data Imported to Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
