| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validate format of values
Client is using WinXP/Office 2003.
He has cells with Canadian postal codes. The postal codes should be 6 characters starting with a letter and then alternating every other with a number. For example, V2L3M4. He would like a formula to evaluate the cell to determine if the postal code follows the correct syntax. Any ideas? -- maryj |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking up a name and then being able to validate it | Excel Worksheet Functions | |||
| Looking up a name and then being able to validate it | Excel Worksheet Functions | |||
| Search and Validate | Excel Discussion (Misc queries) | |||
| How to validate | Excel Worksheet Functions | |||
Threaded Mode
