What should be changed to allow the IMPORTHTML to retrieve a text value?

I get this error message; "Function MULTIPLY parameter 1 expects number values. But "Distribution Rate" is a text and cannot be coerced to a number."

=if(isblank($A17),"",(substitute(index(importhtml("https://www.cefconnect.com/fund/"&A17,"table",2),2,1),"*",""))*1)

CodePudding user response：

use:

=IF(ISBLANK($A17),,(SUBSTITUTE(INDEX(IMPORTHTML(
 "https://www.cefconnect.com/fund/"&A17, "table", 2), 2, 1), "*", )))