| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
international postal codes
Every month I need to validate internation postal codes for acceptable
formats in an Excel 2003 spreadsheet. Some countries have numerous acceptable formats (up to about 20 or so for some) using letters and numbers and sometimes the initials of the country. For example: l = letter n = number Finland nnnnn FI nnnnn FI-nnnnn FInnnnn FIN nnnnn FIN-nnnnn FINnnnnn Canada lnl nln lnl-nln lnlnln Is there a function in Excel 2003 that can do this kind of validation? -- JJ Johnson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell format for Canadian postal codes | Excel Discussion (Misc queries) | |||
| formula for Canadian postal codes | Excel Worksheet Functions | |||
| formula for Canadian Postal Codes | Excel Worksheet Functions | |||
| UK Postal codes in Excel | Excel Worksheet Functions | |||
| Distances between Postal Codes | Excel Discussion (Misc queries) | |||
Threaded Mode
