you obviously need to insert a formula to count which record you're on
(row above plus 1!)

then use =TEXT(serialnumber,"00000") - formats number as
text with 5 digits (adds preceding zeros)

then just join your text to this using &

eg. "ISRC US-ABC-06-" & TEXT (serialnumber,"00000")


--
baxybaxy
------------------------------------------------------------------------
baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824
View this thread: http://www.excelforum.com/showthread...hreadid=556072