|The easiest way would be to use the Data - Text To Columns feature and separate the numbers into their own cells (i.e. A1, B1, C1) and then use a formula like this:|
If the numbers must remain in A1 and A2, then this will work for your example since you only have single digit numbers:
Once you start getting into variable lengths of numbers things get a bit more complicated, e.g.
Now you have to introduce the FIND function to the locate the slashes and then extract the numbers between them.
Just to get the first SUM (35/) from those numbers, you'd need:
Extracting the middle digits requires an even more complicated combination of functions.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.