+ Reply to Thread
Results 1 to 3 of 3

Expand / Collapse number from equation in a cell?

Hybrid View

  1. #1
    Registered User
    Join Date
    03-23-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    67

    Expand / Collapse number from equation in a cell?

    Is there a way to collapse / expand an equation in a cell?

    For instance, I have the following formula (in a cell):

    =140239+89239+89302+200349+503-9393828+998282-383844

    And want to split it respectively by each equation (+ - ) by displaying it in each cell:

    =140239
    +89239
    +89302
    +200349
    +503
    -9393828
    +998282
    -383844

    Usually, I will open a notepad and will do an "enter" to separate them individually, then copy and paste into excel...

    There must be a better way.
    Last edited by jamewoong; 06-14-2015 at 06:10 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Expand / Collapse number from equation in a cell?

    If you replace "+" with " +" and "-" with " -" then you can use text to columns with space as the delimiter:

    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    1
    =140239 +89239 +89302 +200349 +503 -9393828 +998282 -383844
    140239
    89239
    89302
    200349
    503
    -9393828
    998282
    -383844
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Expand / Collapse number from equation in a cell?

    If possible, I'd arrange things the other way around.
    Enter the column of terms
    140239
    +89239
    +89302
    +200349
    +503
    -9393828
    +998282
    -383844


    And let Excel calculate the sum,
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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. Macro to expand a row and then collapse
    By ictodd in forum Excel General
    Replies: 1
    Last Post: 01-18-2015, 04:54 PM
  2. Columns - Expand and Collapse
    By Cecil in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2008, 10:54 AM
  3. Expand/Collapse Rows
    By gammay@gmail.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-18-2006, 04:30 AM
  4. expand/collapse row button
    By caii in forum Excel General
    Replies: 3
    Last Post: 10-26-2005, 05:05 AM
  5. Expand and Collapse Cells?
    By fernandes70 in forum Excel General
    Replies: 1
    Last Post: 03-19-2005, 01:50 PM

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