Insert a new column A and put in a formula like


=left(B2,6)

Put in an appropriate label/header in A1. Drag fill A2 down the column.

Now create you pivot table.

--
regards,
Tom Ogilvy

"Yakimoto" wrote in 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