Excel Formula for auto numbers

[Orion086]

I am in need of some help.  I have a string of text that I have put together and need a final unique number at the end.  So for example ABL267 is strung together and will be used again I need a nonrepeating number that will be at the end. The table below is an example the id column I would like to be automated. Thanks for the help.

FIN#		Product Family	Fixture Component	Manufacturing Process	MACHINE #	id
ABL267A001		A	B	L	267	A001
SFA485A001		S	F	A	485	A001
ZWM262A001		Z	W	M	262	A001
ABL267A002		A	B	L	267	A002

[#2]

@Orion086 

See the attached workbook. I used one extra column.

[#3]

That is fantastic thank you. I was trying to do that but I was getting errors.

Adam

@Hans Vogelaar