Prev Previous Post   Next Post Next
  #1   Report Post  
Jim May
 
Posts: n/a
Default OpeningTextFile

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,,


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"