G
Gerry
I have a single column spread sheet. All cells contain text. However the text lists out separate amounts of money. An example is this (all of it being in a single cell - cell A88 in my case )
£5,175, £105,134, £2,175, £9,831, £10,681, £2,064, £50,853, £3,400, £6,422, £110,552, £433, £33,320, £76,055, £1,104, £24,051, £70,000, £1,966, £5,151, £1,687, £9,011
Another example is this (cell A47 in my case. I show this as it demonstrates negative amounts can be within the text string.
£65,587, £-25,005
Can someone provide me with a clever forumula which can put the sum of the amounts for Cell A1 into cell B1 such that I can copydown cell B1 to the end of my list (which goes down to cell A185)
Many thanks
Gerry.
£5,175, £105,134, £2,175, £9,831, £10,681, £2,064, £50,853, £3,400, £6,422, £110,552, £433, £33,320, £76,055, £1,104, £24,051, £70,000, £1,966, £5,151, £1,687, £9,011
Another example is this (cell A47 in my case. I show this as it demonstrates negative amounts can be within the text string.
£65,587, £-25,005
Can someone provide me with a clever forumula which can put the sum of the amounts for Cell A1 into cell B1 such that I can copydown cell B1 to the end of my list (which goes down to cell A185)
Many thanks
Gerry.