+ Reply to Thread
Results 1 to 4 of 4

Separate positive & negative numbers from on cell

  1. #1
    Registered User
    Join Date
    11-14-2014
    Location
    Thessaloniki, Greece
    MS-Off Ver
    2013
    Posts
    15

    Separate positive & negative numbers from on cell

    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
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-07-2011
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    212

    Re: Separate positive & negative numbers from on cell

    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/

  3. #3
    Registered User
    Join Date
    11-14-2014
    Location
    Thessaloniki, Greece
    MS-Off Ver
    2013
    Posts
    15

    Re: Separate positive & negative numbers from on cell

    thank you for your answer, but i need to separate them.

    regards,
    antonis

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: Separate positive & negative numbers from on cell

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Separate total of negative numbers and positive numbers.
    By avidcat in forum Excel General
    Replies: 3
    Last Post: 04-06-2014, 07:26 PM
  2. [SOLVED] SUMIF positive and negative numbers - take double a negative number?
    By Zordrail in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-16-2014, 08:34 AM
  3. Convert negative to positive in sheet containing both positive/negative numbers
    By sa02000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2010, 07:52 PM
  4. Replies: 2
    Last Post: 01-19-2009, 02:18 PM
  5. Replies: 1
    Last Post: 11-20-2008, 01:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1