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
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
Hello @joelalaball
I believe it should be something like this:
Hello, I will try and let you know, as I’m travelling at this moment. Thanks
Hello Iostapuk, it works, more or less, if I add a formula, with set cell value, when later I get the cell value it paste the formula and not the result