MS Excel cleanup routine

[markem]

I have never written a cleanup routine for excel. All that I have done it write formulas and such.

I find myself in need of a routine that can be run over a set of cells (usually a column) that will strip out an extraneous character from the data set. The specific need at the moment is that I am copying a web page of financial data but the way that the financial institution puts the data up, I wind up with a tab character as part of each column. This isn't too bad except for the columns that contain numbers. I'd like a way to delete the trailing tab character or (much better) remove any non-number from the column/set. Of course, I'd like to keep the '-' sign for negative numbers.

Is there a macro already in MS land that can do this or can anyone give me an idea as to where to go to get the information or, if it is that simple, just post one?

Thanks in advance!!