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

For columnd B:D a formula like

Formula:

=SUBSTITUTE(PROPER(B3),"And","and")

or even change and to & with

Formula:

=SUBSTITUTE(B3,"And","&")

and for column L

Formula:

=UPPER(L3)