Published by admin on October 23, 2024 Here are the 3 formulas I used: 1) =index(split(importxml(A2,”//meta[@property=’og:description’]/@content”),” – See”,TRUE),0,1) 2) =ArrayFormula(value(IFERROR(LEFT(C2,LEN(C2)-1)*LOOKUP(RIGHT(C2),{“K”,”M”},{1000,1000000}),C2))) 3) =D2 [copy and paste this column but with values only so if […]
