I've converted block of text to a single column with 50 rows. Each row now
has a movie title and year the movie was released, a comma, and the
director's name.

Is there a way to split the table into two colums of 50 rows, with the split
occurring at the comma, so that the director's name is in a column separate
from the movie title? (I want to be able to sort by director name).

For those curious, the list of movies is from a new DVD, ESSENTIAL ART
HOUSE: 50 YEARS OF JANUS FILMS.

Thanks for any help anyone can offer.

Table | Convert | Text to Table; Separate at <comma>

--
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.

"danhattan" <(E-Mail Removed)> wrote in message
news:3F2DFD6E-3744-4A22-8EC2-(E-Mail Removed)...
> I've converted block of text to a single column with 50 rows. Each row now
> has a movie title and year the movie was released, a comma, and the
> director's name.
>
> Is there a way to split the table into two colums of 50 rows, with the
split
> occurring at the comma, so that the director's name is in a column
separate
> from the movie title? (I want to be able to sort by director name).
>
> For those curious, the list of movies is from a new DVD, ESSENTIAL ART
> HOUSE: 50 YEARS OF JANUS FILMS.
>
> Thanks for any help anyone can offer.
>
>
>

Thanks, Suzanne. However, this doesn't work because I've already converted
the text to a table. Still, gave it a shot anyway and all it does is nest
blank cell(s) into the first row of the table. The rest of the rows are
pushed down.

Any other ideas?

"Suzanne S. Barnhill" wrote:

> Table | Convert | Text to Table; Separate at <comma>
>
> --
> 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.
>
> "danhattan" <(E-Mail Removed)> wrote in message
> news:3F2DFD6E-3744-4A22-8EC2-(E-Mail Removed)...
> > I've converted block of text to a single column with 50 rows. Each row now
> > has a movie title and year the movie was released, a comma, and the
> > director's name.
> >
> > Is there a way to split the table into two colums of 50 rows, with the
> split
> > occurring at the comma, so that the director's name is in a column
> separate
> > from the movie title? (I want to be able to sort by director name).
> >
> > For those curious, the list of movies is from a new DVD, ESSENTIAL ART
> > HOUSE: 50 YEARS OF JANUS FILMS.
> >
> > Thanks for any help anyone can offer.
> >
> >
> >
>
>

Oh, sorry.

Table | Convert | Table to Text.

Then Table | Convert | Text to Table.

--
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.

"danhattan" <(E-Mail Removed)> wrote in message
news:E860E509-5F66-4D62-9789-(E-Mail Removed)...
> Thanks, Suzanne. However, this doesn't work because I've already converted
> the text to a table. Still, gave it a shot anyway and all it does is nest
> blank cell(s) into the first row of the table. The rest of the rows are
> pushed down.
>
> Any other ideas?
>
> "Suzanne S. Barnhill" wrote:
>
> > Table | Convert | Text to Table; Separate at <comma>
> >
> > --
> > 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.
> >
> > "danhattan" <(E-Mail Removed)> wrote in message
> > news:3F2DFD6E-3744-4A22-8EC2-(E-Mail Removed)...
> > > I've converted block of text to a single column with 50 rows. Each row
now
> > > has a movie title and year the movie was released, a comma, and the
> > > director's name.
> > >
> > > Is there a way to split the table into two colums of 50 rows, with the
> > split
> > > occurring at the comma, so that the director's name is in a column
> > separate
> > > from the movie title? (I want to be able to sort by director name).
> > >
> > > For those curious, the list of movies is from a new DVD, ESSENTIAL ART
> > > HOUSE: 50 YEARS OF JANUS FILMS.
> > >
> > > Thanks for any help anyone can offer.
> > >
> > >
> > >
> >
> >

First use Table > Convert > Table to Text to change the table into
plain text. Then select the same text and use Table > Convert > Text
to Table to convert it to a table, but this time choose the comma as
the separator.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

On Tue, 7 Nov 2006 14:05:02 -0800, danhattan
<(E-Mail Removed)> wrote:

>Thanks, Suzanne. However, this doesn't work because I've already converted
>the text to a table. Still, gave it a shot anyway and all it does is nest
>blank cell(s) into the first row of the table. The rest of the rows are
>pushed down.
>
>Any other ideas?
>
>"Suzanne S. Barnhill" wrote:
>
>> Table | Convert | Text to Table; Separate at <comma>
>>
>> --
>> 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.
>>
>> "danhattan" <(E-Mail Removed)> wrote in message
>> news:3F2DFD6E-3744-4A22-8EC2-(E-Mail Removed)...
>> > I've converted block of text to a single column with 50 rows. Each row now
>> > has a movie title and year the movie was released, a comma, and the
>> > director's name.
>> >
>> > Is there a way to split the table into two colums of 50 rows, with the
>> split
>> > occurring at the comma, so that the director's name is in a column
>> separate
>> > from the movie title? (I want to be able to sort by director name).
>> >
>> > For those curious, the list of movies is from a new DVD, ESSENTIAL ART
>> > HOUSE: 50 YEARS OF JANUS FILMS.
>> >
>> > Thanks for any help anyone can offer.
>> >
>> >
>> >
>>
>>

Thanks very much, Suzanne. Didn't even think to convert back again, then
choose a second delimiter.

"Suzanne S. Barnhill" wrote:

> Oh, sorry.
>
> Table | Convert | Table to Text.
>
> Then Table | Convert | Text to Table.
>
> --
> 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.
>
> "danhattan" <(E-Mail Removed)> wrote in message
> news:E860E509-5F66-4D62-9789-(E-Mail Removed)...
> > Thanks, Suzanne. However, this doesn't work because I've already converted
> > the text to a table. Still, gave it a shot anyway and all it does is nest
> > blank cell(s) into the first row of the table. The rest of the rows are
> > pushed down.
> >
> > Any other ideas?
> >
> > "Suzanne S. Barnhill" wrote:
> >
> > > Table | Convert | Text to Table; Separate at <comma>
> > >
> > > --
> > > 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.
> > >
> > > "danhattan" <(E-Mail Removed)> wrote in message
> > > news:3F2DFD6E-3744-4A22-8EC2-(E-Mail Removed)...
> > > > I've converted block of text to a single column with 50 rows. Each row
> now
> > > > has a movie title and year the movie was released, a comma, and the
> > > > director's name.
> > > >
> > > > Is there a way to split the table into two colums of 50 rows, with the
> > > split
> > > > occurring at the comma, so that the director's name is in a column
> > > separate
> > > > from the movie title? (I want to be able to sort by director name).
> > > >
> > > > For those curious, the list of movies is from a new DVD, ESSENTIAL ART
> > > > HOUSE: 50 YEARS OF JANUS FILMS.
> > > >
> > > > Thanks for any help anyone can offer.
> > > >
> > > >
> > > >
> > >
> > >
>
>

Thanks very much, Jay. Didn't even think to convert back again, then choose a
second delimiter.


"Jay Freedman" wrote:

> First use Table > Convert > Table to Text to change the table into
> plain text. Then select the same text and use Table > Convert > Text
> to Table to convert it to a table, but this time choose the comma as
> the separator.
>
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP FAQ: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the
> newsgroup so all may benefit.
>
> On Tue, 7 Nov 2006 14:05:02 -0800, danhattan
> <(E-Mail Removed)> wrote:
>
> >Thanks, Suzanne. However, this doesn't work because I've already converted
> >the text to a table. Still, gave it a shot anyway and all it does is nest
> >blank cell(s) into the first row of the table. The rest of the rows are
> >pushed down.
> >
> >Any other ideas?
> >
> >"Suzanne S. Barnhill" wrote:
> >
> >> Table | Convert | Text to Table; Separate at <comma>
> >>
> >> --
> >> 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.
> >>
> >> "danhattan" <(E-Mail Removed)> wrote in message
> >> news:3F2DFD6E-3744-4A22-8EC2-(E-Mail Removed)...
> >> > I've converted block of text to a single column with 50 rows. Each row now
> >> > has a movie title and year the movie was released, a comma, and the
> >> > director's name.
> >> >
> >> > Is there a way to split the table into two colums of 50 rows, with the
> >> split
> >> > occurring at the comma, so that the director's name is in a column
> >> separate
> >> > from the movie title? (I want to be able to sort by director name).
> >> >
> >> > For those curious, the list of movies is from a new DVD, ESSENTIAL ART
> >> > HOUSE: 50 YEARS OF JANUS FILMS.
> >> >
> >> > Thanks for any help anyone can offer.
> >> >
> >> >
> >> >
> >>
> >>
>