Hi all,

I have been trying to get a unique ID for a number of entries on my 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 of the spreadsheet is getting greater and greater daily and it would be nice to automate this feature to save a bit of time.

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

Cheers