Get physical address' coordinates of concatenated address in Hebrew using excel formula

Tom Azaria 0 Reputation points

Hi all, I'm trying to add the coordinates (latitude and longitude) of an address in Excel using this formula: =FILTERXML(WEBSERVICE(""&SUBSTITUTE(K2," ","%20")&"&key=[YOUR_BING_MAPS_API_KEY]"),"//Point/Latitude") I'm writing the addresses in Hebrew (RTL), but this doesn't work with English either. Might someone shed some light on this issue I would be grateful. Thank you!

Windows Maps
Windows Maps
A Microsoft app that provides voice navigation and turn-by-turn driving, transit, and walking directions.
246 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. IoTGirl 2,976 Reputation points Microsoft Employee

    Have you tried providing the culture code? The list of supported codes is available in the parameter description on the same page.

    0 comments No comments