Sum & difference between multiple values in a single cell

[iuliandonici]

Hi,

I have given a search on this forum for this matter but I didn't find any solution.

I have 4 coloumns (IN, OUT, IN+OUT, IN-OUT) and N rows. I need to know how can I be able to make a SUM & DIFFERENCE between the IN and OUT values. These values, both in IN and OUT, come into a single cell, separated by ";". Now, you'll probably tell me it's wrong to have multiple values in a single cell but I can't work any other way because the NUMBER of these VALUES is not constant in order to be able to separate them in each coloumn.

Also, the NUMBER of these multiple values in a single cell can be up to 50, 50 values. And each value can have up to 7 digits.

I have linked to you a sample of what I'm trying to do. http://uploaded.to/file/2p39ldok

I know little about VBA programming but I'm willing to do some damage.
I would really appreciate it.
Thank you.

 

[SteveO59L]

I think my first instinct would be to separate out the single cell entries.

Have a look at Text to Columns, with the ";" as the delimiter

 

[iuliandonici]

I think my first instinct would be to separate out the single cell entries.

Have a look at Text to Columns, with the ";" as the delimiter

Thank you for your reply.

Ok, but what about the fact that the NUMBER of values in each cell is NEVER constant? It changes day by day, sometimes there are 3 values, sometimes there are close to 50.

I thought about using "Text to coloumns" too but it's not efficient for my the work I'm trying to do.

Also, I have revised my SAMPLE and tried to make it more specific:
- the values in each cell from IN/OUT/IN+OUT/IN-OUT coloumns should be separeted one from another by ";" and a BLANK SPACE ("34; 45; etc.).
- these values, will never be NEGATIVE.

I'm really sorry if I confused someone, these are some things I just realised. Here's the new URL of the revised SAMPLE: http://uploaded.to/file/elup6ju5 .

 

[iuliandonici]

I might have found something...

 

[iuliandonici]

I have found a pice of code that does just that. Here it is the uploaded file: http://uploaded.to/file/yvv5wmf8