Newbie to Sheets/Excel in general here. I've been trying to look up the answer to my question with no luck so far. Maybe because I'm not sure what to look up exactly.
On to the problem - I have multiple cells with a bunch of data in a single cell, example below:
What I've been trying to do is add the values after the '$' in a single formula.
What I've been doing so far is using split in the next cell, i.e. B1
=SPLIT(A1," ")
followed by an array formula to replace the first 5 characters for each of the values
=ARRAYFORMULA(--REPLACE(B1:P1,1,5,""))
followed by sum
=SUM(B2:P2)
But that involves me repeating that process every time. Is there a way to do it all in a single cell with one formula?
On to the problem - I have multiple cells with a bunch of data in a single cell, example below:
|
What I've been trying to do is add the values after the '$' in a single formula.
What I've been doing so far is using split in the next cell, i.e. B1
=SPLIT(A1," ")
followed by an array formula to replace the first 5 characters for each of the values
=ARRAYFORMULA(--REPLACE(B1:P1,1,5,""))
followed by sum
=SUM(B2:P2)
But that involves me repeating that process every time. Is there a way to do it all in a single cell with one formula?