How to make an address validator in Google Sheets?

D

Di Ma2020-02-05 14:37:47

Google Sheets

Di Ma, 2020-02-05 14:37:47

There is a column A with addresses in a free format. It is necessary to bring them to a single format and display them in column B. So far, I am struggling with scripts for tables and the geocoder API. Maybe there is a better option?

Reply

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

M

Mirtopir2020-04-20 19:45:46

How to transfer the result of work to Google SpreadSheets with scripts? 0Reply

I

Illarion Labahua2018-02-16 22:14:40

How to set conditional formatting based on a cell that is 3 rows above and two columns to the right? 1Reply

E

Evgenia Satonina2020-04-24 16:19:31

How to transfer an image from one sheet to another so that people who have access via the link can see them? 0Reply

L

lugaru72018-02-23 15:56:06

How to duplicate the date of filling a cell into the adjacent one and highlight it with color? 1Reply

A

Alina Shah2020-04-27 16:12:44

How to make a universal age calculation formula? 1Reply

Didn't find what you were looking for?

Ask your question