Wednesday, August 14, 2013

yogi_Set Up A Formula To Extract Spreadsheet_Key From Spreadsheet_URL

                                          Google Spreadsheet   Post  #1332
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Aug, 14 2013   UPDATED Jan-29-2018
user Wgalter (!category-topic/docs/spreadsheets/P3nuLETTVrI)
Is the a formula to estrack just the spreadsheet key
Im looking to be able to extract the spreadsheet key from the google docs active url that sits in between the = and the # signs into a sheet cell of the same spreadsheet

is a script or a formula I could do this with?

Thanks in advance! 
<!- ->