I have some large cells with various data, some (not all) contain a unique
string of charaters which I would like to extract to another cell. The string
of characters is two alphanumerical then six numerical then one
alphanumerical. For those in the UK, like National Insurance numbers. Im not
very good at VB, so would prefer a formula in a cell but beggers can't be
chosers. Thanks for any assistance.