MS Excel cleanup routine

[CigarNut]

Not sure how to do this with a canned macro, but I can write a VB macro do do this... Something like this clears the contents of column 2, rows 1 through 100:

Sub cleanup()

Dim i
For i = 1 To 100

' this clears the cell, but you can use simple or regular expressions to edit.
Cells(i, 2).Value = ""

Next

End Sub