thaa
-
Posts
2 -
Joined
-
Last visited
-
How to use Google Docs to extract GE prices ~By Brainymidget
thaa replied to brainymidget's topic in General Guides
Hello, I tried creating formula for parsing the "m" and "k" prices. The formula would be very big if I would have to merge it with the importhtml formula, so the value loaded from the price list is in D2. =if(iferror(find("m",D2),false),left(D2,find("m",D2)-1)*1000000,if(iferror(find("k",D2),false),left(D2,find("k",D2)-1)*1000,D2)) here is a snapshot: BTW: Thank you for this guide. Really great idea.