Maybe you could assign a unique key for each of those long strings.

Then use =vlookup() to return the long string based on that unique key.

(This may not be much of a solution if you really pivot those tables.)

Darin Kramer wrote:

Howdie...

My Pivot table doesnt display all the data that it is meant to!!
It is effectively running out of charachters
(The source contains a large number of charachters in each individual
cell) Within the source its fine, but within the pivot table drops
charachters from the end.

Alternative solutions to overcome this problem....? Your thoughts are
most welcome!!!

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***

--

Dave Peterson