Removing certain text in multiple filenames in OS X

I had a large number of ebooks that looked like the following:

And because I’m lazy, I looked for an automated way to clean all of them up.  This is how:

1. Back up all your files in another directory
2. Launch terminal
3. Go to the directory you’d like to perform the changes
4. Type: for i in *.mobi; do mv "$i" "`echo $i | sed ‘s/%20/ /g’`"; done
5. That’s it!

Excel: Insert multiple rows every other row

The key is to use a macro.  To do so, hit Alt+F11, then create a new macro and add the code below. Once added, select the worksheet you’d like to process, change the “17” below (1 if to process all rows), then run it.

That’s it.

Sub Insert_Blank_Rows()

    Dim Last As Integer, oRow As Integer
    ‘Count and select rows to process
    Last = Range("A" & Rows.Count).End(xlUp).row
    ’17 is the last row to process (at the top)
    For oRow = Last To 17 Step -1
     If Not Cells(oRow, 1).Value = "" Then
        ‘Copy the line below to as many row insert you need
        ‘in this case, it was 3 row inserts
        Cells(oRow, 1).EntireRow.Insert
        Cells(oRow, 1).EntireRow.Insert
        Cells(oRow, 1).EntireRow.Insert
       End If
    Next oRow

End Sub