maybe

=A2&B1&" for "&JohnSmithCarsSold


--
__________________________________
HTH

Bob

"nathan_savidge" wrote in message
...
Hi,

I have a pivot table, that i am running code on to name the column totals
based on the criteria in the Pivot table. We have a Name, and what it
relates to, i.e. cars purchased would be JohnSmithCarsPurchased. I have
a
front end for this with the individual headers and the names, i.e.
A B C
Cars Sold Cars Bought
John Smith HERE

In the front end i want to put a formula concatenated by the name and the
section, ie.

= (A2 & B1) for JohnSmithCarsSold

Hope this is clear.

Thanks

Nathan.