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   UPDATED Jan-29-2018
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

https://docs.google.com/spreadsheet/ccc?key=0AmwF-VlpbalblabalbalbablahcVNM0E#gid=23

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

Thanks in advance! 

Wilson

--------------------------------------------------------------------------------------------------------------

 

<!- ->