Thanks Max, Works a treat. Appreciate your time end effort - have a great
Chrissy / New Year.
Cheers
Mike

"Max" wrote:

Oops, this part below should have appeared in the post as:

.. And then put in A4 :
=IF($A$1="","",LEFT($A$1,LEN($A$1)-2)&TEXT(ROW(A1),"00"))
Copy A4 down to say A6

(The last line got wrapped around to the formula line)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--