Need a macro to convert a .out (txt) file to excel

[Kim B]

Hello all, this may be easy or not possible at all. This file is originall generated as a .out file, it is easily opened with notepad and can be saved as a txt file, but I can't use txt wizard to convert it in excel. Is it possible to use a macro, or any other method to make this a file excel friendly?

Thanks in advance

Sheet1

*	A
2	Date: 09/10/15 at 2:03 PM
3	* * * * * * * * * * * * * * * * * * * * * * * * * * * THE ABC COMPANY, INC.
4	* * * * * * * * * * * * * * * * * * * * * * * * * *Past Due Items Detail by Customer
5	* * * * * * * * * * * * * * * * * * * * * * * * * * * * * Aged from Due Date
6	* * * * * * * * * * * * * * * * * * * * * * * *Items with a balance greater than $75.00
7	* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *Open Dte Last
8	Invoice # * Date * * * * * * * * Invoice Amt * * Age * * * * * * Balance Payment *Slsp * *Terms * * * * * * * * * * *Cust PO #
9	*
10	Customer: * AAR001 * *COMPANY NAME
11	Contact: * *Hershy/slava * * * * * * * * * * * * * * * * * * * * * * Phone: *XXX/XXX-XXXX
12	*
13	* *189888 *08/21/15 * * * * * * * * *629.17 * *20.0 * * * * * * *629.17 * * * * *STEV * *CASH * * * * * * * * * * * Aaron
14	*
15	*
16	* * * * * * * * * * * *Subtotal for AAR001 * * * * * * * * * * * 629.17
17	* * * * * * * * * * * * * * * * * *Average * * 20.0 * * * * * * *629.17
18	*
19	Customer: * ADL002 * * COMPANY NAME
20	Contact: * *MIKE/BILLY * * * * * * * * * * * * * * * * * * * * * * * Phone: *XXX/XXX-XXXX
21	*
22	* *189824 *08/14/15 * * * * * * * * *827.52 * *27.0 * * * * * * *827.52 * * * * *SIMO * *CASH * * * * * * * * * * * MIKE
23	*
24	*
25	* * * * * * * * * * * *Subtotal for ADL002 * * * * * * * * * * * 827.52
26	* * * * * * * * * * * * * * * * * *Average * * 27.0 * * * * * * *827.52
27	*
28	Customer: * AGK002 * * COMPANY NAME
29	Contact: * *ALFRADO XXX-XXX-XXXX * * * * * * * * * * * * * * * * * * Phone: *XXX/XXX-XXXX
30	*
31	* *189577 *07/14/15 * * * * * * * * 2583.54 * *43.0 * * * * * * 2210.15 08/25/15 ALAN * *NET 15
32	*
33	* *189588 *07/15/15 * * * * * * * * 1392.97 * *42.0 * * * * * * 1392.97 * * * * *ALAN * *NET 15
34	*
35	* *189599 *07/16/15 * * * * * * * * *599.58 * *41.0 * * * * * * *599.58 * * * * *SIMO * *NET 15
36	*
37	* *189683 *07/28/15 * * * * * * * * *793.32 * *29.0 * * * * * * *793.32 * * * * *SIMO * *NET 15 * * * * * * * * * * ISAAC
38	*
39	* *189897 *08/24/15 * * * * * * * * 2271.97 * * 2.0 * * * * * * 2271.97 * * * * *SIMO * *NET 15 * * * * * * * * * * ISAAC
40	*
41	*
42	* * * * * * * * * * * *Subtotal for AGK002 * * * * * * * * * * *7267.99
43	* * * * * * * * * * * * * * * * * *Average * * 31.4 * * * * * * 1453.59
44	*
45	Customer: * ALB001 * * COMPANY NAME
46	Contact: * *ALBERT/MYLEE * * * * * * * * * * * * * * * * * * * * * * Phone: *XXX/XXX-XXXX
47	*
48	* *184432 *02/05/14 * * * * * * * *49243.00 * 582.0 * * * * * * 2590.00 05/28/15 ALAN * *SPECIAL * * * * * * * * * *ALBERT
49	*
50	* *186282 *08/22/14 * * * * * * * * 2920.00 * 384.0 * * * * * * 2920.00 * * * * *ALAN * *Special * * * * * * * * * *Albert
51	*
52	* *187311 *12/04/14 * * * * * * * *30893.00 * 280.0 * * * * * * 7496.00 12/16/14 ALAN * *Special
53	*
54	* *187699 *12/23/14 * * * * * * * *18324.00 * 261.0 * * * * * *12325.00 04/09/15 ALAN * *Special * * * * * * * * * *Albert
55	*
56	* *188215 *02/19/15 * * * * * * * *18502.00 * 203.0 * * * * * *18502.00 * * * * *ALAN * *Special * * * * * * * * * *Albert
57	*
58	* *189495 *07/01/15 * * * * * * * *15990.00 * *71.0 * * * * * *15990.00 * * * * *ALAN * *Special * * * * * * * * * *ALBERT

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:633px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[mole999]

if its purely text, try import csv/txt, then you might need text to columns

 

[Kim B]

i tried that, all it does is put all the data into column A