Hi,
I'm struggling with finding any formula to extract sets of numbers from a cell.
In cell C4 I have the following data "Electric 34, Gas 28, Water 5" (note the commas - are these necessary of would they hinder any formula)? I would like a formula in D4 to sum just the numbers from C4 ie "34+28+5" This would then sum the numbers to "67"
The column C is all the dates of the year and the information (bills I'm paying from my bank account) will change on each row so I can't use the LEFT, MID, RIGHT formulas as this will change for each row and sometimes there won't be any text in column C.
Is there a way? Thanks in advance
P
I'm struggling with finding any formula to extract sets of numbers from a cell.
In cell C4 I have the following data "Electric 34, Gas 28, Water 5" (note the commas - are these necessary of would they hinder any formula)? I would like a formula in D4 to sum just the numbers from C4 ie "34+28+5" This would then sum the numbers to "67"
The column C is all the dates of the year and the information (bills I'm paying from my bank account) will change on each row so I can't use the LEFT, MID, RIGHT formulas as this will change for each row and sometimes there won't be any text in column C.
Is there a way? Thanks in advance
P
