View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JJ Johnson JJ Johnson is offline
external usenet poster
 
Posts: 2
Default 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