Forum Discussion
How to sum the numbers in a text string?
Hi Could anyone help solve the below-attached problem? Unable to figure the formula to get an answer for the stock mentioned in the attached excel sheet. How can I do that by using the formu...
ronakbohra1994 You asked a similar question not too long ago, but than only with "Apple" and you probably didn't get the answer you wanted since you need to include more that just "Apple". I wonder why you work with these text strings containing of a name a number and a plus or minus sign in brackets. So much easier to work with numbers. If you are familiar with PowerQuery, this is relatively easy to perform as shown in the attached file.
Well, the solution attached doesn't solve my problem since the data keeps on changing for every round in the same format.
However, if the format needs to be changed that can be done.
i.e. from Apple 10 (-) it can be changed to Apple -10 or Apple 10-