I would like to convert a word document to and excel doc.
I compile a spare parts list from a program which i have,to email this list
i have found that i can save it as a word doc which everyone can view ,i have
just learnt that to price this list on a site i need to have exel with two
colums.I have worked out that i can open a exel doc in word but not the
other way ,below is what my word doc looks like . For example i need AL57975
and number below in colum B and the quanity 0002 and the number below in
colum A. The other two decriptions are not required.


AL57975 0002 2250 GASKET KIT
L62161 0002 2250 SEAL
L62272 0002 2250 SEAL
L31055 0004 3350 BOOT
AR86923 0004 4555 SEAL
AR94510 0001 4555 FILTER ELEMENT
R34733 0003 4555 SEALING WASHER
AR75603 0002 FILTER
L39035 0001 2250 PLUG

In your word document do a find and replace:
In the following the ^w will find "all white space"
In the following the ^t will insert a "tab mark"
In the Find Box enter ^w
In the Replace Box enter ^t
After this is done - Select all of your document and go to the Menu Bar
and Select TABLE - CONVERT - TEXT TO TABLE.
This will put your document into a table - then you can copy the table
- paste into EXCEL and move the columns around as necessary.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=521281

Thankyou for your suggestion however i am still having trouble keeping
keeping the collums in line ,i followed the ^w then ^t every thing work till
the second replace then the misallinment starts ,thank in advance for any
futher assistance.
Regards Kel

"wjohnson" wrote:


In your word document do a find and replace:
In the following the ^w will find "all white space"
In the following the ^t will insert a "tab mark"
In the Find Box enter ^w
In the Replace Box enter ^t
After this is done - Select all of your document and go to the Menu Bar
and Select TABLE - CONVERT - TEXT TO TABLE.
This will put your document into a table - then you can copy the table
- paste into EXCEL and move the columns around as necessary.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=521281