Thank you for your reply.

I ALSO 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;


- here's an example of how IN+OUT would like to be calculated:
"=SUM(24+23); SUM(33+12); SUM(45+34); etc."

I'm really sorry if I confused someone, these are some things I just realised. I have just attached a revised SAMPLE.

Attached Files

sample2.xlsx (10.8 KB, 13 views)