Hi Chandoo community, I'd be enormously grateful for any suggestions on my tax calculation problem. The issue is how to tell Excel to account for carry forward cumulative tax credits in the cash flow statement, until they are used up and then to revert to a standard method of calculating tax in...
Hi all
I want to extract the word Gas from the text string "Walking Gazelle Gas-Water" - text in cell A15. I have a solution, which is:
=MID(A15,FIND(" ",A15,FIND(" ",A15)+1)+1,LEN(A15)-FIND(" ",A15,FIND(" ",A15)+1)-(LEN(A15)-LEN(RIGHT(A15,FIND("-",A15)))+1))
But I did wonder if anyone...