I am looking for a simple (maybe) formula I can use in the custom Validation area. It will have up to 3 numbers an X in the middle and up to three more numbers at the end. Examples: 1X58 or 100X100 or 545X165 the numbers will be 1 to 999 with a capital X between the 2 sets of numbers. If it doesn't equal its a no go. Kind of new to this so what ever help you can give will help.
Thank you
Bookmarks