Thanks Mike,
Is there any other solution without adding a new column? Is it posible to do
that using pivot table formulas (calculated fields, calculated items or
whatever) ?

"Mike Waldron" wrote in message
...
Hello Yakimoto

The simplest solution is to create a new field in your
data source. Insert a column to the right of the vechile-
number column. Then use the Text to Columns from the
Excel DATA drop down menu. With that command you can
parse the numbers into the new field. Once that is
finished you can form the pivot table you want.

This breakes the original field into two fields. If you
need to keep the original field intact then you could use
the Mid() function to copy only the desired portion of the
original field into the new field.

Mike
-----Original Message-----
Hi everybody!

Is it possible to create a pivot table, but to use only a
part of a field as
a row filed, not an entire field.
I have in the column 'Parts' thge following data
Parts Numbers
---------
Vehicle-Doors 1
Vehicle-Wheels 2

and I woulf like to create a pivot, but somehow to have
Left(part,6), so I
will have grouping by Vehicle only.
I can manage this adding additoonal column to the sheet,
but I think there
should be a way using some formula or so.

Thanks in advance

../Yakimo


.