Converting cell text fields based on Drupal references to numeric values that can be calculated in spreadsheet

Hello,
This is a great module! I am using sheetnode as a field in a content type. I am using the drupal function on the spreadsheet to bring in values from fields of the same content type:
=ORG.DRUPAL.FIELD('my_field')
That works great and the correct data is showing up on the spreadsheet. However when I try to add the cells together I run the
=ISTEXT(A1)
function and it indicates that the cell in fact is a text field. When I run:
=LEN(A1)
I can see that it has 183 characters and is in fact a large string, which would explain why:
=VALUE(A1)
will not convert the text to a number.
When I look at the whole cell using
=T(A1)
I notice that the following is inside the cell:
<div class="field field-name-field-course-scale-success-bench field-type-field-reference field-label-hidden"><div class="field-items"><div class="field-item even">12</div></div></div>
Now if I could access that 12, either via regex, or somehow let the spreadsheet no that this is the value I need then I could run calculations in the spreadsheet which would be super. But I am not sure how to go about this. As another note the Drupal field that is being pulled into the spreadsheet is in fact an integer field.

Thanks in advance for any help,
-Asher