I am using Excel 2013
How do I format Canadian Postal Codes as the data is entered in a cell?
Canadian postal code format is as follows:
Uppercase (A-Z, number(1-9), Uppercase(A-Z) space Number, Letter, Number
e.g. M5M 1G6