SOrt Unique in Word 2k3 Table 1

[MeGustaXL]

Hi there,

1 Excel spreadsheet with lots of text phrases in it, one per row, some unique, many duplicated, a few over 255 characters.

2. Want a Word doc with one instance of each phrase, so I do a Pivot Table to C&P into Word, but - dang! the long ones are truncated to 255 chars!

3. OK, just C&P from sheet to table in Word, but how do I get rid of the duplicates?

Help?

Chris

So you ride yourselves over the fields,
and you make all your animal deals,
and your wise men don't know how it feels...

Ian Anderson

 

[SkipVought]

Hi,

Keeping in mind that Excel is a SPREADSHEET application, pimarily designed to crunch NUMBERS and limited in its TEXT capabilities, use the Advanced Filter to get a UNIQUE list to a new location. Copy from that range.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[MeGustaXL]

Hi Skip, and thanks for your reply.

That don't work I'm sorry to say, for the same reason as the unique listing capability of a PT fails me - some of the cells have more than 255 characters in them in them.

These lengthy ones disply OK, but truncate as soon as I copy them out and paste them elsewhere.

I kinda hoped there was a Unique Sorting function in Word, but I haven't found it yet.

Chris

So you ride yourselves over the fields,
and you make all your animal deals,
and your wise men don't know how it feels...

Ian Anderson

 

[MeGustaXL]

Hi Skip Again, and hevva STAR this time buddy!

Let's just say there was a Man-Machine Interface Malfunction and your method worked exactly as I wanted it to, of course

Thanks again

Chris

So you ride yourselves over the fields,
and you make all your animal deals,
and your wise men don't know how it feels...

Ian Anderson