Canadian Postal Code format

**nmurphy2** · 10-01-2014, 03:36 PM

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

**trisoldee** · 10-01-2014, 04:12 PM

Are you trying to have the cell populate M5M 1G6 without having to type the space?

**nmurphy2** · 10-01-2014, 09:43 PM

Yes
The letters may also be typed in lowercase and converted to uppercase by Excel 2013

**Vikas_Gautam** · 10-01-2014, 11:27 PM

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.

**nmurphy2** · 10-02-2014, 01:01 AM

Thanks, I will try that.

Canadian Postal Code format

LinkBack

Thread Tools

Rate This Thread

Display

Canadian Postal Code format

Re: Canadian Postal Code format

Re: Canadian Postal Code format

Re: Canadian Postal Code format

Re: Canadian Postal Code format

Thread Information

Users Browsing this Thread

Similar Threads

Format Canadian Postal Code on Entry

[SOLVED] Userform for canadian postal code validation?

[SOLVED] Help With Canadian Postal Code In Userform

[SOLVED] Format for Canadian Postal Codes

Adding spaces to Canadian postal code

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions