Now, THAT is slick.............well done Krishnakumar!

Vaya con Dios,
Chuck, CABGx3



"Krishnakumar"
wrote in message
news:Krishnakumar.1s90md_1121493922.2683@excelforu m-nospam.com...

Hi,

Formula in A2 and copied down,

="jn"&--SUBSTITUTE(A1,"jn","")+1

where A1 houses jn51000001

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile:
http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=387666