Excel Formula to Create Google Directions API String (Free Excel Workbook 2007-2010)

Excel Formula to create Google Directions API String

(Free Excel 2007-2010 Spreadsheet)

Download: Google Directions Formula String.xslx

 

If this saved you days of work or you’ll use it in a business environment please consider donating $10
=HYPERLINK(IF(LEN(A6)-LEN(SUBSTITUTE(A6,” “,””))+1=3,”http://maps.google.com/maps?f=d&source=s_d&saddr=”&LEFT(A6,FIND(” “,A6)-1)&”+”&MID(MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256),2,FIND(” “,MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256))-2)&”+”&RIGHT(A6,LEN(A6)-FIND(“*”,SUBSTITUTE(A6,” “,”*”,LEN(A6)-LEN(SUBSTITUTE(A6,” “,””)))))&”,+”&B6&”,+”&C6,”http://maps.google.com/maps?f=d&source=s_d&saddr=”&LEFT(A6,FIND(” “,A6)-1)&”+”&MID(MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256),2,FIND(” “,MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256))-2)&”+”&MID(MID(MID(SUBSTITUTE(A6,” “,”^”,2),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,2)),256),2,FIND(” “,MID(MID(SUBSTITUTE(A6,” “,”^”,2),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,2)),256))-2)&”+”&RIGHT(A6,LEN(A6)-FIND(“*”,SUBSTITUTE(A6,” “,”*”,LEN(A6)-LEN(SUBSTITUTE(A6,” “,””)))))&”,+”&B6&”,+”&C6),IF(LEN(A6)-LEN(SUBSTITUTE(A6,” “,””))+1=3,”http://maps.google.com/maps?f=d&source=s_d&saddr=”&LEFT(A6,FIND(” “,A6)-1)&”+”&MID(MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256),2,FIND(” “,MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256))-2)&”+”&RIGHT(A6,LEN(A6)-FIND(“*”,SUBSTITUTE(A6,” “,”*”,LEN(A6)-LEN(SUBSTITUTE(A6,” “,””)))))&”,+”&B6&”,+”&C6,”http://maps.google.com/maps?f=d&source=s_d&saddr=”&LEFT(A6,FIND(” “,A6)-1)&”+”&MID(MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256),2,FIND(” “,MID(MID(SUBSTITUTE(A6,” “,”^”,1),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,1)),256))-2)&”+”&MID(MID(MID(SUBSTITUTE(A6,” “,”^”,2),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,2)),256),2,FIND(” “,MID(MID(SUBSTITUTE(A6,” “,”^”,2),1,256),FIND(“^”,SUBSTITUTE(A6,” “,”^”,2)),256))-2)&”+”&RIGHT(A6,LEN(A6)-FIND(“*”,SUBSTITUTE(A6,” “,”*”,LEN(A6)-LEN(SUBSTITUTE(A6,” “,””)))))&”,+”&B6&”,+”&C6))

Leave a Reply

Your email address will not be published. Required fields are marked *