Formatting Canadian Postal codes

Is there something a person can do for improper formatting on Canadian postal codes where the person typed a number "0" instead of a letter "O" and vice versa? We come across this problem all the time.

Thank you for this video. Does anyone know if this also works for cases with no breaking spaces (Ascii code 160) instead of regular spaces (Ascii code 32)?

bro. thank SOOOOO much. i was so stressed out.

Well damn. This formula doesn't work for me.

You have just saved me SO much time!!! Thank you!!

Awesome, thanks alot.

cool