Harish V·Follow1 min read·Aug 24, 2020--1ListenShareHere's the actual string you can use :)=if (C5 <> "", ifna(1*Substitute(Substitute(INDEX(IMPORTHTML("https://finviz.com/quote.ashx?t="&SUBSTITUTE(C5,".","-"),"table",11),4,4),"*",""),"-",""),0),"")Replace C5 with your cell number