Apply formulas in excel

joelalaball · October 4, 2019, 9:09am

Hello,

I want to apply this formula in Excel in the cell B34 =SUBSTITUTE(A34;"-";""). And then for the rest of the column until I have blank data.

I can’t find how to apply formulas in Excel.

Thanks

iostapuk · October 4, 2019, 9:08am

Hello @joelalaball
I believe it should be something like this:

Please note that in order to apply the formula, you need to add “Get cell Value” as described below.
Also, I believe the formula is =SUBSTITUTE(A34,"-","")

iostapuk · October 9, 2019, 12:44pm

@joelalaball

Did this solution help you?

joelalaball · October 10, 2019, 6:51am

Hello, I will try and let you know, as I’m travelling at this moment. Thanks

iostapuk · October 17, 2019, 9:08am

Hi @joelalaball did you have time to check it?