VBA to compare cell formats

VBA would help ..

Here is the qtn if two cells A1 and A2 has "ab 1" and "ab 2" the answers for comparing cells should be true as both cells has first 2 letters as alphabets then space followed by numeric..format of
cells is same. if you can give me a VBA it would be great
help.

Thanks for the help!

Thank you ..

Here is what exactly i am looking ..in the below link u will find each state driving license formats of each state..example for alabama 7 Numeric..for ALASKA Up To 7 Digits..what am i looking is if we select a specific state and then insert any driving license of that state in next cell if the format matches i want that next cell to be true if not false ..wonder if we can create anything like this ..there are about 50 states with different lisence formts..

Please check if we can write a VBA for this ..



http://www.diogenesllc.com/stdlformats.html