See this previous thread

http://tinyurl.com/yecyrp

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Paul G" <Paul wrote in message
...
I would like to get help in creating a function to put into a cell with
the
UK postal code, normally 2 letters then 1 or 2 numbers, space then 1
number
followed by 2 letters eg. WR9 9EP or WR10 3EH