Merlin’s weekly podcast with Dan Benjamin. We talk about creativity, independence, and making things you love.
Merlin’s weekly podcast with Dan Benjamin. We talk about creativity, independence, and making things you love.
”What’s 43 Folders?”
43Folders.com is Merlin Mann’s website about finding the time and attention to do your best creative work.
Open Thread: How are you using Excel?
Merlin Mann | Aug 22 2006
Yesterday, I mentioned I'd been talking with someone who's looking at interesting things people are doing with Microsoft Excel. I talked to her again yesterday, and with her official okey-dokey, I'll virtually introduce Tralee Pearce (*waves*), a reporter from Toronto's Globe & Mail whom you might remember from a very swell article about the Hipster PDA. So, by request -- and to help Tralee with fleshing out her fun-sounding article -- I hope you all will jump in here: What kind of cool, novel, and non-obvious stuff are you doing with Excel? What's the wildest, most obsessive, most nerdy thing you ever saw someone do with our favorite spreadsheet program? 119 Comments
POSTED IN:
![]() This is more twisted that...Submitted by tbk (not verified) on August 22, 2006 - 5:33am.
This is more twisted that wild, but it works. I'm on Windows and I use it for turning out DOS batch files that run the same command on lots of different files. I use DOS to list the file list to a text file using 'more > textfile.txt'. I open that list in Excel and then I have a list of all the files in a column. From there I can write the command in the columns around it and fill down so it's reapeated lots of times. Then I export it as a TAB delimited text file, do a find and replace to remove the tabs, rename it as a .bat and it's ready to run. » POSTED IN:
|
|
EXPLORE 43Folders | THE GOOD STUFF |