Capital each word excluding “and” in the post code column all letters in upper case

What I would like to achieve is capitalise to each word, but exclude the “and” word and in the post code column all the letters in upper case. I got the code from the net it is not doing what I want
As per sample: Mr and Mrs, not, Mr And Mrs
Post code: RE11 1WP, not, Re11 1Wp