Hi.

I've got a web query which goes off and translates a list of words
within a sheet - it works quite nicely, except any special characters
seem to get messed up in the process.

For example, if I navigate to the website directly and enter a word to
translate ("Invalid" in this example), I am correctly returned
"Unzulässig". However in Excel this gets changed to
"Unzulässiger".

Anyone have any ideas what I can try to get the correct character
formatting?

Many thanks