Excel Formula to Create Google Directions API String (Free Excel Workbook 2007-2010) Posted on January 12, 2012 by Joe Tandle 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)) Share this:Click to share on Twitter (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Google+ (Opens in new window)Click to email this to a friend (Opens in new window)MoreClick to share on Pinterest (Opens in new window)Click to share on Reddit (Opens in new window)Click to print (Opens in new window)Click to share on Tumblr (Opens in new window)Like this:Like Loading...