excelent wrote:

* try put in A1 and copy down

="abc"&TEXT(ROW(),"00000000000")&"abc" *


Thanks to everyone who helped. The above suggestion worked perfectly.