open an Excel file as a Word doc

[marybeth]

I have an Excel file with 16 sheets that I would love to
be able to open in a Word format. I can open it, but when
I do, it is a table format with ALL of the columns across!

Can I get rid of the table formatting and convert it into
text?

Or can I just have it import the used columns?

Help!

[Cindy Meister -WordMVP-]

Hi Marybeth,

If you assign a RANGE NAME to the columns you want to import,
you can specify that via the RANGE button in Word's
Insert/File dialog box (it sounds like that's the interface
you're using).

If you want the table as delimited text, you can select it,
then use Table/Convert Table to Text

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister
http://www.mvps.org/word
http://go.compuserve.com/MSOfficeForum

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail :-)

[wilson...@gmail.com]

Well in that case if you need to convert multiple sheets into one single doc i would recommend you to use Total Excel Converter tool for this. Total Excel Converter is the perfect choice to convert any type of table.With Total Excel Converter, you can convert each sheet into a new file. Imagine how much time you'll save with this amazing conversion tool. Instead of spending hours trying to gather various converters for each file type, download the one tool that can handle them all!

excel converter - http://www.coolutils.com/TotalExcelConverter

Source: Personal experience