Forum Discussion
Split cell and Calculate formula
Hi, Little introduction: I try build complex and clear excel too calculate servals aspect of game economy, for beeter play and learn much more about excel. Including all that causes me a problem...
Noxam, so far there is no TEXTSPLIT() formula in Excel. You may use FILTERXML() to split the text, but I don't think everything could be done in one cell, even with combining everything by LET().
First you shall split text lines, after that each line split on text and number which gives array in array; after that make some aggregation using arrays elements.
As variant you may make such particular aggregation in Power Query, but it depends on how the data is structured and what else you need to have in resulting table except mentioned data.
If speak about separate cells, perhaps for the converting text in one cell into the sum in another cell VBA will be better solution.