Forum Discussion

SanthoshKumarArutperunjothi10's avatar
May 30, 2025
Solved

Unable to take the htmlpage value for formula

Unable to use the htmlpage value for formula  
  • ExcelExciting's avatar
    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.