Hi

One way, assuming your data is in column A, enter this formula in B1
=--MID(A1,2,len(a1)-1)
Copy down the column

Regards

Roger Govier


Josh O. wrote:
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