I have to copy a table out of a web page and paste into excel and then add
formulas to the spreadsheet.

When I try to sum a column of figures, I get a "0" result because the
numbers have a "$" before the number and a space after the number.

Is there any way to either sum them as they are, or remove the $ and space
in all the cells?

Example (each cell has a space after the last number):
$300.00
$126.67
$269.17
$180.00