Google Spreadsheets Tips & Tricks
1. Extract URL from an Hyperlink
The formula use in D2 is =REGEXEXTRACT(FORMULATEXT(A2); C2)
The Regex is (http.*)”;”
2. Import JSON data into your spreadsheets
There is an article here that explique how to do https://medium.com/@paulgambill/how-to-import-json-data-into-google-spreadsheets-in-less-than-5-minutes-a3fede1a014a
3. Link data between 2 sheets
Todo so you can use the formula =VLOOKUP(D2,List!A:B,2,0)
