Validation of Postal Code

Hi;

is there a way to validate CND postal codes in a spreadsheet? If not how can
I format the column to accept only A9A9A9 type of data? (Upper case,
number,uppercase, etc.)
Thank you,

Veronika