Google Spreadsheets Quick tips

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 3. Link data between 2 sheets Todo so you can use the formula =VLOOKUP(D2,List!A:B,2,0)