Remove $ sign and space before and after in range

Good day to all!

I am copy pasting from a webpage that has 6 columns.

Column A = Date
Column B = Description (phrase; more than 1 word)
Column C to F = Dollar amount

The layout of Columns C to F is " $1,000.00 " (space before and after the dollar amount)

This is not letting me do an autosum in the progress bar as well as the a formula as excel does not recognise it as a number

* I did a Text-to-column delimiter on the Space but Column B is being split into separate columns because of the multiple words in the description.

I appreciate anyone who can help in a line/lines of code that calls Range(C:F & lastrow) and removes the spaces and the dollar sign on paste event.

Try selecting all the data in columns C to F and then do two Replace All commands. The first needs to replace $ with nothing, that is, put a $ sign in the first box and leave the second empty. And the second one needs to replace space with nothing. Might be worth replacing the comma with nothing in the middle but you might get away with that.

Note that with Text to Columns, you can only work on one column at a time. Why did you use it on column B?

Originally Posted by InvisibleMan

Try selecting all the data in columns C to F and then do two Replace All commands. The first needs to replace $ with nothing, that is, put a $ sign in the first box and leave the second empty. And the second one needs to replace space with nothing. Might be worth replacing the comma with nothing in the middle but you might get away with that.

Note that with Text to Columns, you can only work on one column at a time. Why did you use it on column B?

Sorry I did not explain the Text to Columns bit in detail. I did a pastespecial as text and it put Columns A-F as one string (column A)

Maybe use the $ sign as the delimiter then.