I can e-mail a few of the fields if you want. Each cell is usally around
600-800 characters long of messages relating to a membership, so a lot of, he
said, she said and some where you get things like "casemem no is NR623454C"
or "t/p advised HG674398P won't attend" and "BH346799R to remain linked and
open" its the NR623454C HG674398P BH346799R that I would like to copy to a
new column, leaving it blank if the membership no doesn't appear.

"Biff" wrote:

Hi!

For the best possible solution you'll need to provide several examples.

Biff

"Did" wrote in message
...
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.