I've been searching the web for a way to generate a unique, sequential alpha-numeric value (i.e., MFTP001, MFTP002, etc.) for each new 'project' entered into a worksheet.

The generated value needs to be permanently 'assigned' to that project and not change throughout its lifespan, regardless of the addition/deletion of rows around it.

Ideally, the value will populate its cell when a value in entered into one of four other cells on the same row (e.g., different project types).

So far, everything I have found only covers 'dumb' sequential numbering or numbering of rows 1 through whatever, that auto-number when a row is added or deleted.

Is this possible?

Thanks in advance!