(no subject)

[machine_dove]

Why does Excel suck and not let me do cool grep things like "delete the first two characters in every cell in this column." Nooooo...instead I'm doing it by hand. And getting it to the point where I could do it by hand required two hours of data massaging. And completely throwing away some rows that fell into the "what the fuck is this!?!" category.

*THUD*

If I'm a good girl I'll get to walk around the building with Buck later in the week, wrenching PCs away from people by force if need be. Spreading hate and discontent is my job, I suppose.

[EDIT] Ha! kethylia liked it just as much as I did!.

Comments

Excel doesn't totally suck... (now with corrected code)

[iridium753.livejournal.com]

B1 = RIGHT(A1,LEN(A1)-2)

Though don't get me wrong, I still hate excel. ;)

Re: Excel doesn't totally suck... (now with corrected code)

[mordath.livejournal.com]

Neat! That doesn't do quite what I'm looking for, but REPLACE might, if I can convinced this particular damned spreadsheet to cooperate...

Thanks, man!

Re: Excel doesn't totally suck... (now with corrected code)

[iridium753.livejournal.com]

No problem, there's all kinds of dirt under "string functions" in the help if you're looking for stuff like this.

[geoduck.livejournal.com]

This should work: =mid(A1,3,len(A1)-2)

Re: Excel doesn't totally suck... (now with corrected code)

[nathanbp.livejournal.com]

Once you get it working, you can use copy & paste special...values to get just the values so you can delete the originals.