array formula
=SUM(IFERROR(--MID(A1,ROW(1:100),1),""))