HTML into Excel won't go...

[John R]

I have copied a table from a WEB page and pasted it into Excel (2000). One
column looks like figures (pounds and pence) but it cannot be totalled using
autosum.

I have tried formatting the column (and whole sheet) to currency, text,
general etc. with no effect, it will not autosum.

I have discovered that each cell contains a hidden character before the
figures which is not a space.

Question...
....is there an easy(ish) way of removing the hidden characters (many
hundreds of rows) so I can total (autosum) these figures?


Regards

John R

 

[Frank Kabel]

Hi
use the following macro:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

 

[John R]

Hi Frank,

Danke, that macro works and I can now autosum the figures.

Thanks again,
John R