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     www.energyefficientbuild.com.   Aug, 14 2013
user Wgalter (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/P3nuLETTVrI)
Is the a formula to estrack just the spreadsheet key
Hi,
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! 
Wilson
--------------------------------------------------------------------------------------------------------------