# Data Validation with mixed numbers and a single letter

1. ## Data Validation with mixed numbers and a single letter

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

2. ## Re: Data Validation with mixed numbers and a single letter

Is "X" represent for any single string? Is it able to be "Y" ,"Z", "@" or any single string?

3. ## Re: Data Validation with mixed numbers and a single letter

If B2 need Validation
Try:
``Please Login or Register  to view this content.``

4. ## Re: Data Validation with mixed numbers and a single letter

@bebo021999,

You need to change both of your 999's to 1000 otherwise 999X# or #X999 (where # is a stand-in for any number less than 1000) will be blocked.

5. ## Re: Data Validation with mixed numbers and a single letter

@bebo021999,

Also another condition is required to confirm both numbers >=0, otherwise the following will accept;

-1X-1
1X-1

6. ## Re: Data Validation with mixed numbers and a single letter

That is a good point Haseeb! I have reworked bebo021999's formula to overcome the problem you and I found while still keeping it somewhat short...

Formula:
`Please Login or Register  to view this content.`

There are currently 1 users browsing this thread. (0 members and 1 guests)