How about:

="SupplierCode"&ROW()

If they are all in the same column and you never change rows.