OP here—wow, thanks for all the replies!
Tried the REGEXEXTRACT trick and it worked for the numbers. Still struggling with IMPORTXML tho—keeps giving me errors.
Anyone got a dummy-proof example for that?
Also, the Power Query tip for Excel sounds promising—gonna test that next.
Y’all saved me hours of googling. Cheers!
Tried the REGEXEXTRACT trick and it worked for the numbers. Still struggling with IMPORTXML tho—keeps giving me errors.
Anyone got a dummy-proof example for that?
Also, the Power Query tip for Excel sounds promising—gonna test that next.
Y’all saved me hours of googling. Cheers!
