I'm new here and don't really do much programming in Excel VBA, so go easy on me
What I'm trying to accomplish is take a record spanning ten rows, but in one column and have each piece of data display as it own column.
Attached is an example.
If you notice, when you import the txt file into Excel, the address spans between A2-A6, if dumped into one column(Sheet 1).
Sheet2 shows the fields with fixed columns, as best as I could get them without cutting off data
Please advise
Thanks in advance
Bookmarks