Forum Discussion
SanthoshKumarArutperunjothi10
May 30, 2025Copper Contributor
Unable to take the htmlpage value for formula
Unable to use the htmlpage value for formula
3 Replies
Sort By
- SergeiBaklanDiamond Contributor
That's Google Sheets question, isn't it?
yes, that for google sheets.
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.