LinkBack URL
About LinkBacks
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
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
Are you trying to have the cell populate M5M 1G6 without having to type the space?
Yes
The letters may also be typed in lowercase and converted to uppercase by Excel 2013
For example ..
If you enter m5m1g6 in A1
try this formula to make it perfect..
Formula:
Please Login or Register to view this content.
You can also try worksheet change event to do this automatically..
If Column A is where you wanna put the rough postal code then try..
Please Login or Register to view this content.
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Thanks, I will try that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks