Contents of Cell

[ptrifile]

I am looking to find if a cell contains a 12 digit string of numbers. This cell can and does contain numbers and text, it is used as a "notes" field and I am looking for a formula/VBA that would return a yes or no if anywhere in the cell a string of 12 numbers(a credit card number) appear together in that cell.

Any help or suggestions welcome.

Thank you!

Paul

 

[SkipVought]

Hi,

How about the Find() function?

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[ptrifile]

I thought of the find() or Search() functions as well but what i cant figure out is how to have the formula search or find for a 12 digit number in the contents of the cell. I am assuming that the IF and LEN() functions would come into play as well but i cannot seem to figure the logic or correct context to get the desired results.

 

[ptrifile]

I was able to solve this by using REGEX in excel using "\b(?:\d[ -]*?){13,16}\b".

 

[SkipVought]

I am looking to find if a cell contains a any 12 digit string of numbers.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[ptrifile]

Skip, that was my mistake....12, 16 same difference!