4,375 questions
On the problem of Excel function translation, I hope someone can provide some help.
Kern
1
Reputation point
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.
Microsoft 365 and Office | Development | Other
Sign in to answer