sum values between characters

[a.hudrea]

Hello guys,
I need some guidance in finding a solution for this problem.
I have the following text in a cell FS320702-10 : 08-05-2017 : 30; FS322658-05 : 26-05-2017 : 40; FS333658-05 : 26-05-2017 : 40; FS444658-05 : 26-05-2017 : 40;.
I need the sum of the values that appear before ";" so this would translate to 30+40+40+40.
FS320702-10 : 08-05-2017 : 30; represents value 30. There could be up to 10 to 15 values in one cell.
Thanks.

[Tsjallie]

This function should do that job for you.
It first splits up the cell by the ;-delimiter and then splits up the separate parts by the :-delimiter. Then 3rd part of the latter will have the value to add.

Please Login or Register  to view this content.

Add a module to your workbook and copy this code to it.

[a.hudrea]

It works amazing. I'm a beginner when it comes to vba and I honestly didnt know about split and ubound functions.
If it's not to much trouble could you explain your thought process? Did you had this issues before or this solution just came to your mind on the spot?
Anyway ty so much for your help.

[Tsjallie]

...could you explain your thought process?

To be honest I really don't have a clue of what's happening between my ears
But I think it's mainly looking for structure and applying knowledge of functions.

Thx for the rep