All,

I am having big problems removing spaces.

I have copied a HTML table into excel. a typical cell might contain a number and spaces infront and behind it.

E.G Cell A1 contains " 10000 ", 8 characters (2 spaces)

I used the TRIM command and it does not work as the cell A1 still contains 8 characters instead of 5.

Note the numbers are stored in General format.

Any ideas?

David32