Multiple Date inside one cell

[Marsman]

I receive this from a program in this format where the data is in one cell. I'd like to take a list of numbers in that format, which would vary in length (say 1-25 entries or more), and calculate its sum. is there a way to pars each row out of this cell to place into individual cells or somehow to get a total?

Example:

A B 1 Charges Total 2 1500.00 250.00 150.00 <tbody> </tbody>

<colgroup><col width="64" span="2" style="width:48pt"></colgroup><tbody>
</tbody>

Thanks in advance

 

[Joe4]

Take a look at this thread here:
http://www.mrexcel.com/forum/excel-questions/363279-text-delimited-soft-return.html

 

[Marsman]

Thanks for that. works great.

 

[Kenneth Hobson]

' =SUMbyvblf(A2)
Function SumByVBlf(aCell As Range) As Double
  Dim d As Double, v As Variant
  For Each v In Split(aCell, vbLf)
    d = d + v
  Next v
  SumByVBlf = d
End Function