I have a Word 2000 document in three tabbed columns (not a table). How can
I convert this to Excel so that the columns are retained in separate cells?

Peter

In Word: Table, Convert, Text to Table(using the tabs as separator).
Then select the "new" table and Copy paste to Excel.

HTH

Gilles


"Peter" wrote in message
...
I have a Word 2000 document in three tabbed columns (not a table). How can
I convert this to Excel so that the columns are retained in separate cells?

Peter

Thanks, but the situation is rather more complex. The resulting cells and
rows do not line up correctly.

The difficulty is that the columns in each row are separated by 1 to 4
tabs,
depending on the amount of text in the cell. Also the third column consists
of many rows consist of more than one line. Each line and row is a
paragraph. I attach an extract from the document.


Peter

"Gilles Desjardins" wrote in message
. ..
In Word: Table, Convert, Text to Table(using the tabs as separator).
Then select the "new" table and Copy paste to Excel.

HTH

Gilles


"Peter" wrote in message
...
I have a Word 2000 document in three tabbed columns (not a table). How
can
I convert this to Excel so that the columns are retained in separate
cells?

Peter

Please don't post attachments here. Before you convert the text to a table,
add or remove tab characters so that there are the same number in each
paragraph. If you have used more than one tab character in order to use
Word's built-in tab stops, DON'T! Set a specific tab stop for each column;
use more than one tab character only when a column is empty. See
http://word.mvps.org/FAQs/Formatting/SettingTabs.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Peter" wrote in message
...
Thanks, but the situation is rather more complex. The resulting cells and
rows do not line up correctly.

The difficulty is that the columns in each row are separated by 1 to 4
tabs,
depending on the amount of text in the cell. Also the third column
consists
of many rows consist of more than one line. Each line and row is a
paragraph. I attach an extract from the document.


Peter

"Gilles Desjardins" wrote in message
. ..
In Word: Table, Convert, Text to Table(using the tabs as separator).
Then select the "new" table and Copy paste to Excel.

HTH

Gilles


"Peter" wrote in message
...
I have a Word 2000 document in three tabbed columns (not a table). How
can
I convert this to Excel so that the columns are retained in separate
cells?

Peter

Thanks

"Suzanne S. Barnhill" wrote in message
...
Please don't post attachments here. Before you convert the text to a
table,
add or remove tab characters so that there are the same number in each
paragraph. If you have used more than one tab character in order to use
Word's built-in tab stops, DON'T! Set a specific tab stop for each column;
use more than one tab character only when a column is empty. See
http://word.mvps.org/FAQs/Formatting/SettingTabs.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

"Peter" wrote in message
...
Thanks, but the situation is rather more complex. The resulting cells
and
rows do not line up correctly.

The difficulty is that the columns in each row are separated by 1 to 4
tabs,
depending on the amount of text in the cell. Also the third column
consists
of many rows consist of more than one line. Each line and row is a
paragraph. I attach an extract from the document.


Peter

"Gilles Desjardins" wrote in message
. ..
In Word: Table, Convert, Text to Table(using the tabs as separator).
Then select the "new" table and Copy paste to Excel.

HTH

Gilles


"Peter" wrote in message
...
I have a Word 2000 document in three tabbed columns (not a table). How
can
I convert this to Excel so that the columns are retained in separate
cells?

Peter

Hi Suzanne, I did not post any attachments. I do not see any paper clips in
my news reader (Outlook Express).
Is there a problem with my reader?

Gilles
"Suzanne S. Barnhill" wrote in message
...
Please don't post attachments here. Before you convert the text to a
table,
add or remove tab characters so that there are the same number in each
paragraph. If you have used more than one tab character in order to use
Word's built-in tab stops, DON'T! Set a specific tab stop for each column;
use more than one tab character only when a column is empty. See
http://word.mvps.org/FAQs/Formatting/SettingTabs.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

"Peter" wrote in message
...
Thanks, but the situation is rather more complex. The resulting cells
and
rows do not line up correctly.

The difficulty is that the columns in each row are separated by 1 to 4
tabs,
depending on the amount of text in the cell. Also the third column
consists
of many rows consist of more than one line. Each line and row is a
paragraph. I attach an extract from the document.


Peter

"Gilles Desjardins" wrote in message
. ..
In Word: Table, Convert, Text to Table(using the tabs as separator).
Then select the "new" table and Copy paste to Excel.

HTH

Gilles


"Peter" wrote in message
...
I have a Word 2000 document in three tabbed columns (not a table). How
can
I convert this to Excel so that the columns are retained in separate
cells?

Peter

My reply was to Peter, who posted an attachment, visible in OE (but not in
the Web interface).

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Gilles Desjardins" wrote in message
. ..
Hi Suzanne, I did not post any attachments. I do not see any paper clips
in
my news reader (Outlook Express).
Is there a problem with my reader?

Gilles
"Suzanne S. Barnhill" wrote in message
...
Please don't post attachments here. Before you convert the text to a
table,
add or remove tab characters so that there are the same number in each
paragraph. If you have used more than one tab character in order to use
Word's built-in tab stops, DON'T! Set a specific tab stop for each
column;
use more than one tab character only when a column is empty. See
http://word.mvps.org/FAQs/Formatting/SettingTabs.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup
so
all may benefit.

"Peter" wrote in message
...
Thanks, but the situation is rather more complex. The resulting cells
and
rows do not line up correctly.

The difficulty is that the columns in each row are separated by 1 to 4
tabs,
depending on the amount of text in the cell. Also the third column
consists
of many rows consist of more than one line. Each line and row is a
paragraph. I attach an extract from the document.


Peter

"Gilles Desjardins" wrote in message
. ..
In Word: Table, Convert, Text to Table(using the tabs as separator).
Then select the "new" table and Copy paste to Excel.

HTH

Gilles


"Peter" wrote in message
...
I have a Word 2000 document in three tabbed columns (not a table).
How
can
I convert this to Excel so that the columns are retained in separate
cells?

Peter