Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've been provided a text file (sample.txt) which I desire to import into
Excel. It is too big to open in Notepad (a message provided), and I don't seem to have Wordpad (on my PC,,??), so just to view it and get an idea of how it is layed out I opened it in MS Word (I've got Office XP). The data is exactly like it appears IN HARD-COPY. It is a detailed Accounts Receivable transaction report reflecting ALL transactions for a full month - Cust Name, PrevBal, Charges (vertical), payments, etc... EndingBal The data is in portrait-layout and word-wrapping and snaking columns is everywhere..^%^(*)*,,, Looks to me that this text file needs "cleaning up" before I attempt to open with Excel. Where can I go (to get what I need) in order to find out what I need to do? Wow, that was a mouth full. Any help greatly appreciated,, |