Extract Numbers from Calculation String

[jski21]

Good day Mr. Excel Team,

Is there a way (probably) to extract numbers from a calculation string? Example:

=0+36888+13321+10141

First number is Q1, second is Q2, etc. The number of digits is not static and will be more or less depending on performance. Difficulty is extracting the correct number when the string has the same character (+) to try to extract from and the dynamic nature of the digits. Ideally, these would be separate formulas for each Q.

Thanks in advance for the review and help.


jski

 

[Scott Huish]

It would be better if you put each of those numbers in it's own cell, and summed them.

 

[jski21]

Yeah I get it Scott but that's not the way the data is coming over from the originator and there's lot's of it.

 

[Cubist]

Use Text-to-Column with "+" as your delimiter.