Are you looking for an excel formula?
I didn't see a sample file attached, just your text posted here.
You just want a formula that can take a string like
"56/15s" and turn it into a fractional number?
OH, I see. It's all just one XML document in column A of the sheet then?
That'll take some more doing than a simple formula. I will have to take some time to study it.
Here's something to head you in the right direction. You can see how the working cells extract the parts of the string needed and convert the numbers.
There are some cases where the input string doesn't have a denominator, you can just add a "/1" after the number manually to get it to work.
Hi,just following up, were you able to use my solution? Please feel free to post any additional questions, comments or concerns you may have regarding this issue.
If you're not yet satisfied with the result, please let me know what is missing. I will do my best to make it right for you.
Otherwise, please don't forget to rate my service - I don't get paid for my work until your rating is received.