MS Excel cleanup routine

CigarNut · 07-11-2012, 11:19 AM

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

markem · 07-11-2012, 11:23 AM

Thanks, Michael. However, I am trying to take a cell with a number that looks like "123 " (note the space at the end) and removes all non-numbers to get "123" (no space). It's easy to do in C, since isanumber is there. There are specific instances where the number might not be terminated by a space, so I can't just delete the last character of the string. Also, I suspect that sometimes, that space is a tab.

07-11-2012, 11:19 AM	#1
CigarNut Fck Cancer! Join Date: Jan 2009 First Name: Michael Location: Clermont, Florida Posts: 18,042 Trading: (111*)	Re: MS Excel cleanup routine 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 __________________ Need Beads? Need Five Finger Bags? 2 of 3 Requirements for use of the CA Rolodex: 100 posts/ 60 day membership/ participation in trade (trader rating). New members can be added at any time.

07-11-2012, 11:23 AM	#2
markem Bunion Join Date: Oct 2008 First Name: Mark Location: Second Star on the Right Posts: 22,664 Trading: (47)	Re: MS Excel cleanup routine Thanks, Michael. However, I am trying to take a cell with a number that looks like "123 " (note the space at the end) and removes all non-numbers to get "123" (no space). It's easy to do in C, since isanumber is there. There are specific instances where the number might not be terminated by a space, so I can't just delete the last character of the string. Also, I suspect that sometimes, that space is a tab. __________________ I refuse to belong to any organization that would have me as a member. ~ Groucho Marx