Hello. I have never been able to get macros to work. Maybe I'm using them wrong.

Is the following task possible with a macro?

In a cell there is: Stop($20.00)

What I need to do is remove the word Stop, the two parentheses, and the dollar sign; so that only the number, 20.00, remains.

I have many cells that I need to perform this task in; so I can reference the number in the cells to use in an algebraic formula.

I am not a novice Excel user. However, for some reason I have never gotten a grasp on what macros will and will not do.

Thank you very much.

Bill Bowers