Hi,
I have received a large file of text and numbers arranged (loosely) in columns in a .txt file that I need to get into a usable form in Excel.
I'm trying to use the Text Import Wizard but am running into problems geting the column breaks right as there are thousands of rows of data items. As soon I think that I've inserted the break line in the correct place I scroll down a little further to find an item that encroaches into the next column, and when I shift the break line to the right to accommodate this new item I then encroach on the items in this next column.
Can someone please offer some guidance about how to sort this out?
Thanks!
Bookmarks