GreenFire63

Silly me. You're awesome. Many thanks.

I tried your second suggestion on that, after typing in: =IF(Isnumber([D4]), [D4],MID([D4],2,9)) I got an error message and when I double clicked on the cell, this showed up.... =IF(Isnumber([R[-1]C[-5]]), [R[-1]C[-5]],MID([R[-1]C[-5]],2,9)) Any ideas?

Aging Miser, tyvm. Thats...complicated :shock: Is it possible to make a find+replace function for a single cell deleting a +? That's a very BIG problem for me, just getting rid of the damn plus sign!

Stragomagus' suggestion should work, I was going to make the same suggestion: scrubbing regedit clean of norton files.

I have a technical problem with google docs. As I'm sure some of you are aware, you can use google docs to track xp, store current ge prices, make calculators, etc etc. I'm making a list of items that I need and merchant frequently. Importing the data was no problem, the problem comes with calculating daily percent changes. When you import price change information from the rs item database, it attaches a plus and a minus to signifiy increases or falls. For some reason, Google docs is having difficulty understanding that a plus means positive. No issues on the minus symbol though. I'm guessing that the plus sign is considered text, which is why it screws up my calculations. (though that doesn't explain why the minus works) I would just delete the plus sign, but since the data is imported from an html table you can't exactly do that. I've tried doing "=Value(text)" but that doesn't work. Could someone experienced with html help me out with this problem? An html code deleting the plus sign or a code for google docs to understand that it means positive would be GREATLY appreciated. Below is the code I used to import data: =Index(ImportHtml("http://itemdb-rs.runescape.com/results.ws?query=cosmic rune", "table", 2),2) And code I used to convert k's and m's to *1000 and *10000000 =if(iferror(find("m"C50),false),left(C50,find("m",C50)-1)*1000000,if(iferror(find("k",C50),false),left(C50,find("k",C50)-1)*1000,C50)) ^both from "How to use Google Docs to extract GE prices ~By Brainymidget" found at viewtopic.php?f=180&t=782319 My knowledge of html is fairly limited lol, but maybe its possible to use my conversion code to change "+" to a space or *1? Maybe work off of this fail code? hahaha =if(iferror(find("+"D4),false),left(D4,find("+",D4)-1)*1,D4) ^it didn't work for me btw hahaha Thanks :)

Have the entire code that you want to have in that cell in notepad first, edit as needed, then copy+paste the whole code into the cell. You can't, or even if you could, shouldn't, copy+paste bits and pieces of the code into a single cell multiple times, opens up opportunities to screw up the code and is very tedious. Also, while you are editing a single cell, google docs prohibits you from pasting; its only meant for manual editing. Does that help?

Personally, I have a copy of the code in notepad, edit it from there, then paste it into google docs. Makes it much easier.

I realized that for most items "#N/A" is displayed right after GE updates, when the items' prices are getting updated. (right after GE update my entire page is full of that) Usually, it takes GoogleDocs around 20-30 minutes to have the new price showing. Since items on the GE aren't updated all at once and some even get double updated, expect #N/A to be there up to 30 minutes after item updates at many times of the day EDIT: Realized that its not limited only to ge updates.

First of all, absolutely wonderful guide, should help me lots in everything ;) Someone mentioned the problem of + in the price change column, and the problem was never really addressed. This problem interferes with the ability to make a column with daily percentage changes. Would it be possible to eliminate the + from this column using the importhtml code? Or any way to convince googledocs that the "+" means positive? If this is too difficult, any other code eliminating the + would be greatly appreciated Also, is it possible to make the "m" and "k" conversions directly in the importhtml code?