Hi everyone,

I can't find a custom format to validate a properly formatted Canadian postal code on entry, so I think my last hope is to ask someone to write me a VBA code.

Canadian postal codes consist of six characters with a space in the middle: a capital letter, a number, a capital letter, a space, a number, a capital letter, and a number. Therefore, M2A 3J4 is a properly formated postal code.

I want a code to fix an improperly fomatted postal code (such as M2A3J4 or m2a3j4 or m3a 2j4) on entry.

Can anyone please help me?

Thanks,
Gos-C

__________________
Using Excel 2007/Windows XP

"It is better to be prepared for an opportunity and not have one, than to have an opportunity and not be prepared."