Converting Fidelity fund research to Google Sheets

Converts this: 

To this: 

Version 1 of formula:

=mid(A2,1,if(isnumber(find("%",A2)),find("%",A2)-1,""))

Version 2 that filters out blanks better: 

=if(isnumber(find("%",N53)),mid(N53,1,find("%",N53)-1)/100,"")