Hi all,

I have been trying to get a unique ID for a number of entries on m
spreadsheet, the way I have came up with this is Initial first name
Initial second name, date of birth & initial of gender.

It looks like this L-F-12/10/1966-M, but now the number of entries o
the spreadsheet is getting greater and greater daily and it would b
nice to automate this feature to save a bit of time.

Is there a way that this can be done, your help is greatl
appreciated.

Cheer

--
Clas
-----------------------------------------------------------------------
Clash's Profile: http://www.excelforum.com/member.php...fo&userid=1895
View this thread: http://www.excelforum.com/showthread.php?threadid=54283