String manipulation and pattern recognition

I'd like to know how to identify if a cell's contents meets certain requirements. Specifically I want to determine if there is Credit Card information in a given cell. The information in a given cell is written free hand and in no certain order. The following string patterns should trigger the code to indicate that there is cc info in the cell.

A "#" is equivalent to any integer.

#### #### #### ####
cvv
################
####-####-####-####

I've only gotten as far as to think that i may need to enter all of the characters into an array and do something from there. So basically I just want to be able to look through a paragraph of writing in a cell and determine if it has any of the above patterns within.

See VBE Help for the Like operator.

If you're looking to use formulae the below:

=SUMPRODUCT(LEN(A1)-LEN(SUBSTITUTE(A1,{0,1,2,3,4,5,6,7,8,9},"")))=16

will tell you if there are 16 digits in the string