At home we get up and walk away and let him scream it out. He's usually over it within seconds.
Out and about it's distraction

Aren't they fun
Yep, what Helle said. We just completely ignore and he now knows it gets him nowhere. If I'm at the shops or something I always have a list of things in my head applicable to where we are, like "Let's go get some bananas" etc.