IMPORTTEXT & IMPORTCSV functions in excel

Example 1: one file with dropdown list =IMPORTTEXT(A2&A3,,,-2) Example 2: from a webpage =IMPORTTEXT("https://gml.noaa.gov/aftp/data/trace_gases/co2/flask/surface/txt/co2_mlo_surface-flask_1_ccgg_month.txt", {0,4,9,13,20},54) Same link further back: https://gml.noaa.gov/aftp/data/trace_gases/co2/flask/surface/txt/ Example 3: multiple files =CHOOSECOLS(VSTACK(IMPORTTEXT(A1),IMPORTTEXT(A2,,1),IMPORTTEXT(A3,,1),IMPORTTEXT(A4,,1),IMPORTTEXT(A5,,1),IMPORTTEXT(A6,,1),IMPORTTEXT(A7,,1),IMPORTTEXT(A8,,1)),2,3,4,7)