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.
|