Tag Info

Hot answers tagged

2

Assuming you have a new line character in every cell and you want to extract everything before the new line, try: =ArrayFormula(iferror(regexextract(A2:A, "^(.+)\n"))) (where A is the column with the addresses and your data starts in row 2 --> change to suit). After that, you can copy the output and use 'paste special' (values only) to overwrite to ...


2

If you click the cog icon at the bottom, and then click "Share or embed map", you get a link. If you email the link to yourself (I know, sounds archaic) and open it on your phone, you can choose to open the directions in the Google maps app. The great thing about this method is it can transfer a custom route you made when dragging the route to make it go a ...


1

Wikipedia has useful bookmarklets accessing archive.org's Wayback Machine here


1

I created a command-line tool to handle this.



Only top voted, non community-wiki answers of a minimum length are eligible