Html Data Not Pulling Out In Google Spreadsheet

I have tried to pull out HTML data from NSE website in my google spreadsheet, but script symbol containing '&' is not getting pulled out but other normal scripts which does not

Solution 1:

Try wrapping the stock ticker in an ENCODEURL function. It loaded the data for me.

=importhtml("https://www.nseindia.com/marketinfo/sym_map/symbolMapping.jsp?symbol="& ENCODEURL("M&M") &"&instrument=OPTSTK&date=-&segmentLink=17","table", 3)