To do what you want, you need a VBA solution. Formulae can't "push" values to cells, they can only calculate values or bring in values from other cells.

I would try and find out exactly what Google Maps requires before proceeding with the processing of your raw data. It could save doing a lot of work for nothing.