openning a word file in excel

[Dave Peterson]

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.

ruthie wrote:
>
> 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?

--

Dave Peterson
ec3...@msn.com

[Max]

Try this

In Excel:

Click Insert > Object
Select 'Create from File' tab
Use the Browse button to navigate to your .doc > Insert
Click OK

ruthie <rsi...@optonline.net> wrote in message
news:3ac601c37b16$7d008970$a601...@phx.gbl...

[ruthie]

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!

>.
>

[Dave Peterson]

I'm still confused about the way it looks in Word.

Is it a table with name/address/city-state in each cell (on different lines, but
in the same cell?)

Or is it just plain old text?

Either way, when you copy|Paste into excel, don't you end up with a different
row for every line?

If yes, then it sounds like you want to do Copy|paste special|transpose to take
each of that name/address/city-state and put them all on one row???

If each grouping is exactly 3 rows with a blank row (group of 4) between them,
you can use helper columns to to the transposition.

Put this formula in B1:
=INDEX(A:A,(ROW()-1)*4+1,1)
and in C1:
=INDEX(A:A,(ROW()-1)*4+2,1)
and in D1:
=INDEX(A:A,(ROW()-1)*4+3,1)

And drag down until you run out of data.
select columns B:D.
Copy|pastespecial Values
delete column A

If your data isn't always grouped by 4, then this won't work. But if there's
some indicator (blank row???), then there are other ways to do what you want.

--

Dave Peterson
ec3...@msn.com