Hi there,
I'm trying to figure out how I can create a formula to create an easy list for ISRC numbers. (http://en.wikipedia.org/wiki/Interna...Recording_Code)
My ISRC Codes are like this:
NL-C20-13-00001 (where NL is the country, C20 my company ID, 13 the year 2013 and 00001 is the sequence which refers to the track)
So what I'm trying to fix is that my excel sheet makes the number automatically like this:
NL-C20-13-00002
NL-C20-13-00003 etc.
I've been trying: ="NL-C20-13-"&TEXT(A1+1)
and tried to modify it a bit, but I can't really get it to work yet.
So I hope someone has a solution for me.
Thanks in advance!
Bookmarks