machine_dove: (Albert Getaway)
Add MemoryShare This Entry
posted by [personal profile] machine_dove at 01:59pm on 04/10/2005
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! [livejournal.com profile] kethylia liked it just as much as I did!.
There are 5 comments on this entry. (Reply.)
 
B1 = RIGHT(A1,LEN(A1)-2)

Though don't get me wrong, I still hate excel. ;)
 
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!
 
No problem, there's all kinds of dirt under "string functions" in the help if you're looking for stuff like this.
 
Once you get it working, you can use copy & paste special...values to get just the values so you can delete the originals.
 
posted by [identity profile] geoduck.livejournal.com at 05:01am on 05/10/2005
This should work: =mid(A1,3,len(A1)-2)

June

SunMonTueWedThuFriSat
  1 2 3 4 5 6
7 8 9
 
10
 
11 12
 
13
14
 
15
 
16 17 18
 
19
 
20
 
21
 
22
 
23
 
24
 
25
 
26
 
27
 
28
 
29
 
30