Hello everyone,
attached you'll find my new thread
i have positive and negative number in one cell and i want to separate them or sum them in two new cells
Hello everyone,
attached you'll find my new thread
i have positive and negative number in one cell and i want to separate them or sum them in two new cells
If you want then you can get directly answer which is 20 in the given case. You need to just remove first quotation which you added.
Regards,
Suhas
Don't Follow me My Way Is Dangerous.
http://3dmotionmedia.in/services/
thank you for your answer, but i need to separate them.
regards,
antonis
That still leaves the separating positive and negative numbers results.
I think you need to look at why the data is in this format in the first place.
You may be able to solve this a lot easier if you're able to change the data before it gets to this stage.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks