openning a word file in excel

  • Thread starter Thread starter ruthie
  • Start date Start date
R

ruthie

I'm try to open a simple word document in excel. when I
click on the .doc filename I get the message:
file format is not valid
can someone please help?
 
You could open the .doc in word and copy|paste into excel.

You could insert a word document (insert|object) into the workbook.

But you can't open it directly (for importing??) in excel.
 
Try this

In Excel:

Click Insert > Object
Select 'Create from File' tab
Use the Browse button to navigate to your .doc > Insert
Click OK
 
I guess I wasn't very clear. I have a word document, it
contains names and addresses in this format:

name
addressline
city-state

name
addressline
city-state

name
addressline
city-state

and so forth.

I want to load the info into excel, each row is a
name/addressline/city-state, each of the three pieces of
info is a separate column. (ie row1 column1 is name, row1
column2 is addressline, row1 column3 is city-state).

I think I should be able to do this (or something very
close to it, I'm willing to 'massage' the data a little if
I have to). Any ideas? Thanks!
 
Back
Top