When you paste this link:

http://www.mrexcel.com/forum/s­howthread.php?p=2659126#post26­­59126

Be sure that no extra dashes "-" are inserted, I had a bit of trouble with it. The subject line on the post is:

Validating Postal Codes In Excel

JHtraining,

I was curious if there was a better way and so I posted a question here:

http://www.mrexcel.com/forum/s­howthread.php?p=2659126#post26­59126

JHtraining,
But, that formula is too long to go into the Data Validation Custom text box. The limit is 255 characters. The only way I could get it to work was to put the logical formula in a column next to it, then build a Logical Formula in the Data Validation Custom text box that points to that cell.

Sound complicated. It is. This is an example of why Excel is great for all the "on the fly" stuff we do, but for real database stuff, it is not the best.

There may be a better way, like with VBA, but I do not know. THE smartest Excel people that answer questions are here:

mrexcel.com/forum

JHtraining, Here is a Logical Formula that will validate a postal code:

=AND(AND(EXACT(LEFT(A2,1),UPPE­R(LEFT(A2,1))),ISTEXT(LEFT(A2,­1)),NOT(ISNUMBER(LEFT(A2,1)+0)­)),ISNUMBER(MID(A2,2,1)+0),AND­(EXACT(MID(A2,3,1),UPPER(MID(A­2,3,1))),ISTEXT(MID(A2,3,1)),N­OT(ISNUMBER(MID(A2,3,1)+0))),M­ID(A2,4,1)=" ",ISNUMBER(MID(A2,5,1)+0),AND(­EXACT(MID(A2,6,1),UPPER(MID(A2­,6,1))),ISTEXT(MID(A2,6,1)),NO­T(ISNUMBER(MID(A2,6,1)+0))),IS­NUMBER(RIGHT(A2,1)+0))

I mentioned it is much easier in Access.

JHtraining,
1) Access database is specifically made to do that. In Excel, it could be done with a TRUE FALSE formula (Logical Formula), but it would be THE biggest Logical Formula that I have ever done (and I have done some big ones). I will try to post an example later. But the effort in Excel to create this is MUCH harder than in Access. Databases are specifically built to validate all kinds of data. Stay Tuned for Excel formula...
2) The Book and DVD can be bought separately or together. However, the book can be bought anywhere, at any store. The DVD can only be purchased (starting next week) from:
http://www.mrexcel.com/
The reason is that the DVD is released during the middle of the book season and no book stores will pick it up until Jan 2012.
The good news is that mrexcel.com will have the DVD and Book bundled at a discount -- available next week.

Fishtard1,
1) I am sorry about not having Danish videos for you -- English Excel is all I know...
2) Videos 23 to 89 were low quality and so I deleted them and re-did all of them. Although the numbers are not the same, all the content is in other videos. If you search the excelisfun channel by the topic you want, you should be able to find a video to help. If you do not know how to search the excelisfun channel, go to the excelisfun channel and watch the video that auto-plays: it shows all the tricks for find just the video you want.
3) Here is a playlist of all the Excel 2010 videos that I have made:

http://www.youtube.com/user/ex­celisfun#g/c/A1F22CE787E693BF

When entering the Postal Code, it needs to the (letters in Caps) Letter - Number - Letter (space) Number - Letter - Number, ie A0A 1A0

Thanks, So love your work!!!

ps. will the CD come with the book or are they different products?

Cheers,
Juanita

Your videos is very good! I learn a lot from it. One thing is bothering me though. The formulars is NOT the same in danish and it is causing some troubles. I want my office pack to be in english because it will be easier to go through your videos and because they use the english version on my school. I can't find a way to change the language. Do I really have to buy an English version aswell? please help :/

And two little questions:
Why delete video 23-89?
Have you made a video about the major changes in 2010?

/Asger S

JHtraining, I don't understand your question. Can you explain a bit more what you are trying to do.

Is there an easy way for Data Validation for Canadian Postal codes?