On the problem of Excel function translation, I hope someone can provide some help.

Kern 1 Reputation point
2021-12-05T07:38:47.41+00:00

The function translation on Excel uses =FILTERXML(WEBSERVICE("http://fanyi.youdao.com/translate?&i="&A1&"&doctype=xml&version"),"//translation"). The result returned is the result in the red circle in the figure below. Can you modify this formula so that the result is the result in the blue circle in the figure below. Or can you use other functions to make the website used for Excel translation as "https://dict.youdao.com/ ", obtain the results in the green circle in the figure below.155071-1.png155063-2.png155064-3.png

Microsoft 365 and Office | Development | Other
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.