Forum Discussion
SanthoshKumarArutperunjothi10
May 30, 2025Copper Contributor
Unable to take the htmlpage value for formula
Unable to use the htmlpage value for formula
May 31, 2025
When you are retrieving the value, it is returning as text due currency symbol "₹"
Below formula shall be helpful for you.
=VALUE(SUBSTITUTE(INDEX(IMPORTHTML("https://www.goodreturns.in/gold-rates/bangalore.html","table",1),2,2),"₹",""))
If this resolves your query don't forget Mark as Solution.