[Excel] Why aint chrome/mozilla xpath working in Excel importxml

According to this:
https://support.google.com/docs/answer/3093342?hl=en


I put this in excel
=IMPORTXML("https://mydomain.com", "//a/@href")

and it works.

then I put:
=IMPORTXML("https://mydomain.com", "Xpath Copied From Google Chrome Or Mozilla")

And I get errors.

ErrorFormula parse error.

Why is this?



Is there any working way to extract html from a webpage?