How to link in Google Sheets to Google Maps search?

Question

Android

Good day to all users.
Faced such task. On duty, he must move around the city from house to house. There is a Google Spreadsheet with addresses and house numbers, keys, an entrance, etc. I know some addresses, but the situation is different with the rest - you need to go to Google Maps or Yandex.Maps, enter this address and actually move to it.
So the question is - how would it be in this Google Spreadsheet (but if necessary I can move to MS Excel) to make a cell / button / link so that when clicked, data is taken from column A (street) and B (house number) Google Maps opens and happens here Search?
Platform - smartphone with Android 4.4.2 (Not PC)

Answer 1

So ?

Answer 2

I have more than a thousand lines: manually type, take a link, insert it into a page on a newly created site, that's a lot of work!!! On the contrary, I wanted to automate everything - insert some function into column C, stretch it to the end and poke while working.