Archive of Mr Excel Message Board

Back to Other Office and Excel archive index
Back to archive home

From Word to Excel

Posted by Anthony on August 06, 2001 1:20 PM

I'm at it again trying to transfer a word document into excel. A few of you were kind enough to post suggestions, however, I'm still not having any luck. I've followed each and every method as per excel itself. If anyone knows of any little secrets, I'd greatly appreciate it.

Thanks

Anthony

Re: From Word to Excel

Posted by lenze on August 06, 2001 2:25 PM

Try saving the Word File as a Text File. Then use the import Text Wizard.

Re: From Word to Excel

Posted by Anthony on August 07, 2001 4:54 AM

If I do it that way, it places all of the data in one cell. The data is set up in two columns of about 3-4 lines of information.

Any other suggestions?

Thanks

Anthony

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.