starting withis formula :
=SUM(A2:A4)+LEFT(A1,FIND("*",A1)-1)

suppose i would like to add more "left" like :

=SUM(A2:A4)+LEFT(A1,FIND("*",A1)-1)+LEFT(A10,FIND("*",A10)-1)+
LEFT(A11,FIND("*",A11)-1).....

how can i shorcut that ?