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

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,533 questions
0 comments No comments
{count} votes