Hello
I have a problem with some names that have spaces, wildcards or other characters like apostrophe '.
Below are some examples of name and two other links. The links do not work due to the name written using the Concatenate function.
I need help replacing those characters in the concatenate formula, somehow that Excel recognizes it and the browser also. This is part of a function I wrote, so I need this to become a valid link. The name in question will be in Cell B4 from the concatenate formula.
=CONCATENATE("https://maps.googleapis.com/maps/api/place/nearbysearch/xml?location=",C4,",",D4,"&radius=200&types=food&name=",B4,"&sensor=false&key=AIzaSyBATWM92nRl-vM87CxNV6gu3WtbU5c_ay8")
@15 Abchurch Lane Restaurant & Bar
+65 / Plus-Six-Five Supper Club
https://maps.googleapis.com/maps/api...es=food&name=6 St Chad's Place&sensor=false&key=AIzaSyBATWM92nRl-vM87CxNV6gu3WtbU5c_ay8
https://maps.googleapis.com/maps/api...es=food&name=A & G Thompson&sensor=false&key=AIzaSyBATWM92nRl-vM87CxNV6gu3WtbU5c_ay8
Thanks
Bookmarks