I want the numbers at the end of the name to increment.

The idea of the numbers is that if their are two or more members wit
the same First letter of first name and surname i.e. B Jones (ID
BJon), the numbers will be used to make a unique id. So if there wer
2 ben jones the first one would have 001 and the second would have 002
creating

BJON001
BJON002
CJON001 - as it has a different first letter and is the first instanc
of the name so 001.

Is that any bette

--
bac
-----------------------------------------------------------------------
bach's Profile: http://www.excelforum.com/member.php...fo&userid=2613
View this thread: http://www.excelforum.com/showthread.php?threadid=46894