I don't think there's one magic product.  Just a good carpet cleaning,
cleaning of the  plastic parts (dash, door panels, if plastic) etc.

What Larry said.  Just clean everything well.  I like Murphy's Oil Soap
for vinyl (use some non-abrasive mechanic's hand cleaner with lanolin
for really bad vinyl,) and I've found the best way to get a "film" off
the windows is with aerosol window cleaner and 0000 steel wool,
followed by window cleaner and a paper towel.  No, this will not
scratch your windows nor will it hurt a defogger grid.  You should see
the glass on my '55 Stude, it is stunning now that I have done this.  I
end up doing that to all my cars about once a year, and I don't even
smoke (anymore.)  But if you have cloth upholstery and carpet you will
have to have those cleaned as those will hold whatever is in the car,
and if you have a cloth headliner you may never completely get rid of
the smell (as there's no practical way to clean one without destroying
it.)  However, if everything else is well cleaned, that will go a long
way.

nate

This should come in handy

http://www.mystoresupplier.com/ProductDetails.asp?ProductCode=LIT018

(just kidding)

But seriously, the smell will always be there.  After the car has rusted
away to nothing, the smell will still be there.  -Dave

There are only two ways.  First, smoke.  Smokers can't smell anything,
even their own body odor.  Second, don't ever smoke in a car.