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

You can find a possible solution here

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you SO VERY MUCH! You helped me more than you will ever know! This is going to save me many hours per month in my job!!!!!!!!!!! I tried it and it worked perfectly!

You're welcome

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post