Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Word document to Excel 1

Status
Not open for further replies.

mitchellr

Programmer
Feb 2, 2004
10
AU
Just wondering if there is a way to convert a word document to excel.

My issue is I am trying to retain formatting, so the
Word>Select All>Copy>Excel>Paste Special>Text isnt really
returning the formatting as I would like it.

Also trying to achieve the result without preparing a macro.

Any other suggestions would be appreciated.

Thanks
 
For a one-page Word document, you could use the Insert|Object|From File approach. Other than that, you'll find it difficult or impossible to replicate the Word document in Excel. The Copy & Paste approach is really only good for tabular data and/or bringing across text strings.

Cheers
 
Hi,
I would try to:
1. Convert doc to txt using word;
2. Excell->File->Open ( mark "all files" ) -> your txt file;
3. It should open "Text Import Wizard",
from there - mark "Delemited and "Next",
- choose actual delimeter and Finish.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top