edit " +$" from entries in a column of data

[Olivepetunia]

I have a workbook created by copying data from a website. Every amount is preceded by "+$", which I would like to eliminate so that only the value remains.
Yes, there is a space before the "+".
There are hundreds of rows.
I tried creating a macro to eliminate this. I recorded these steps: "edit, home, delete, delete, delete, enter." five times. When I run this macro on a different group of cells, it replaces the contents of those cells with the contents of the original cells which were used to create the macro.

The code reads:
{code}' Keyboard Shortcut: Ctrl+y
'
ActiveCell.FormulaR1C1 = "763.7"
Range("I60").Select
ActiveCell.FormulaR1C1 = "898.96"
Range("I61").Select
ActiveCell.FormulaR1C1 = "329.09"
Range("I62").Select
ActiveCell.FormulaR1C1 = "37.82"
Range("I63").Select
ActiveCell.FormulaR1C1 = "109.59"
Range("I64").Select
End Sub

Clearly creating a macro with the recorder does not work in this case. Assistance would be appreciated.
Thanks

[sktneer]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[StuCram]

Try this…

Create this macro.
Select the data and then run it to remove the + and $ symbols from the first 2 positions of each cell and create a numeric results.

Please Login or Register  to view this content.

Hope this helps.

[jolivanes]

If there are only 3 characters (space, + and $), then a formula would do
Assuming the data is in cell C1 and down:
In a free column and copy down
=RIGHT(C1,LEN(C1)-3)

Or with code:

Please Login or Register  to view this content.