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

Re: Word doc to Excel? by Gilles

Gilles
Sat Feb 25 07:38:16 CST 2006

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" <kealties@peterbhurst.f2s.com> wrote in message
news:eW1AjEgOGHA.3864@TK2MSFTNGP10.phx.gbl...
>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
>



Re: Word doc to Excel? by Suzanne

Suzanne
Sat Feb 25 12:28:18 CST 2006

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" <kealties@peterbhurst.f2s.com> wrote in message
news:OCZESuiOGHA.2124@TK2MSFTNGP14.phx.gbl...
> 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" <gilles.desjardins3@sympatico.ca> wrote in message
> news:P4ZLf.31812$%14.747626@news20.bellglobal.com...
> > 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" <kealties@peterbhurst.f2s.com> wrote in message
> > news:eW1AjEgOGHA.3864@TK2MSFTNGP10.phx.gbl...
> >>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
> >>
> >
> >
>
>
>


Re: Word doc to Excel? by Peter

Peter
Sat Feb 25 13:39:11 CST 2006

Thanks

"Suzanne S. Barnhill" <sbarnhill@mvps.org> wrote in message
news:%23p4QUljOGHA.2696@TK2MSFTNGP14.phx.gbl...
> 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" <kealties@peterbhurst.f2s.com> wrote in message
> news:OCZESuiOGHA.2124@TK2MSFTNGP14.phx.gbl...
>> 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" <gilles.desjardins3@sympatico.ca> wrote in message
>> news:P4ZLf.31812$%14.747626@news20.bellglobal.com...
>> > 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" <kealties@peterbhurst.f2s.com> wrote in message
>> > news:eW1AjEgOGHA.3864@TK2MSFTNGP10.phx.gbl...
>> >>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
>> >>
>> >
>> >
>>
>>
>>
>



Re: Word doc to Excel? by Gilles

Gilles
Sat Feb 25 17:14:43 CST 2006

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" <sbarnhill@mvps.org> wrote in message
news:%23p4QUljOGHA.2696@TK2MSFTNGP14.phx.gbl...
> 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" <kealties@peterbhurst.f2s.com> wrote in message
> news:OCZESuiOGHA.2124@TK2MSFTNGP14.phx.gbl...
>> 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" <gilles.desjardins3@sympatico.ca> wrote in message
>> news:P4ZLf.31812$%14.747626@news20.bellglobal.com...
>> > 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" <kealties@peterbhurst.f2s.com> wrote in message
>> > news:eW1AjEgOGHA.3864@TK2MSFTNGP10.phx.gbl...
>> >>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
>> >>
>> >
>> >
>>
>>
>>
>



Re: Word doc to Excel? by Suzanne

Suzanne
Sat Feb 25 18:13:55 CST 2006

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" <gilles.desjardins3@sympatico.ca> wrote in message
news:ex5Mf.32075$%14.814525@news20.bellglobal.com...
> 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" <sbarnhill@mvps.org> wrote in message
> news:%23p4QUljOGHA.2696@TK2MSFTNGP14.phx.gbl...
> > 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" <kealties@peterbhurst.f2s.com> wrote in message
> > news:OCZESuiOGHA.2124@TK2MSFTNGP14.phx.gbl...
> >> 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" <gilles.desjardins3@sympatico.ca> wrote in message
> >> news:P4ZLf.31812$%14.747626@news20.bellglobal.com...
> >> > 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" <kealties@peterbhurst.f2s.com> wrote in message
> >> > news:eW1AjEgOGHA.3864@TK2MSFTNGP10.phx.gbl...
> >> >>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
> >> >>
> >> >
> >> >
> >>
> >>
> >>
> >
>
>