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

Tom Azaria 0 Reputation points
2023-04-23T09:55:28.78+00:00

Hi all, I'm trying to add the coordinates (latitude and longitude) of an address in Excel using this formula: =FILTERXML(WEBSERVICE("https://dev.virtualearth.net/REST/v1/Locations?q="&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
    2023-04-25T21:26:14.5933333+00:00

    Have you tried providing the culture code? https://learn.microsoft.com/en-us/bingmaps/rest-services/common-parameters-and-types/culture-parameter. The list of supported codes is available in the parameter description on the same page.

    0 comments No comments