?

Log in

No account? Create an account

Previous Entry | Next Entry

Wheee :) Porn pays off!

I spent the last two hours teaching a nice young couple a bunch of level 2-3 Excel tricks--formatting, filtering, concatenation, things like that. They basically do photo permissions, pulling photos for big ol' textbooks, and then crediting those photos to the artists that took them.

One of the more tedious tasks the husband did, was take loooong (4000 lines or so) lists of data, paste them into Word, then delete the line-breaks, by hand.

OMG, that's slow. But one quick trick involving find-replace, that I discovered while reformatting texts I wouldn't want my mom to know about, reduces this process to about four find-replaces. Yay! Smut--it's good for business :)

Comments

( 4 comments — Leave a comment )
prophetsurfer
Apr. 10th, 2007 03:01 pm (UTC)
OK this should TOTALLY be in the Excel community!
spottylogic
Apr. 10th, 2007 03:03 pm (UTC)
Sure, I'll post it there. Actually it's a trick that the Admin-Prof community would benefit more from.
prophetsurfer
Apr. 10th, 2007 03:44 pm (UTC)
I was referring to the porn-reference juicing up the Excel peoples a lil... hahaha I like to ruffle their feathers and call them secksi, make references to vulgarity, etc. It's foon!
spottylogic
Apr. 10th, 2007 03:47 pm (UTC)
*tsk, tsk*
( 4 comments — Leave a comment )

Latest Month

August 2011
S M T W T F S
 123456
78910111213
14151617181920
21222324252627
28293031   
Powered by LiveJournal.com
Designed by Taylor Savvy