12 Replies Latest reply: Jun 30, 2014 3:02 PM by Jerrold Green1
Nick-Thirteen Level 1 Level 1 (0 points)

I cannot find the cell split option on the latest version on Numbers - can anyone point me in the right direction - thank you


Aperture 3, OS X Mavericks (10.9), MacBook Pro 2.8GHz core 2 Duo, 8GB
  • 1. Re: How can I split cells in Numbers 3.0.1
    SGIII Level 5 Level 5 (4,135 points)

    Hi Nick-Thirteen,

     

    Not sure if this is what you mean, but this is how you can "Unmerge" already merged cells.  It's in the Table menu.

     

    Screen Shot 2013-12-04 at 1.11.15 PM.png

     

    SG

  • 2. Re: How can I split cells in Numbers 3.0.1
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    Hi Nick,

     

    In Numbers 3, there is no "Split", only Merge and Unmerge.

     

    This means al lot more planning is necessary when designing a table.

     

    Jerry

  • 3. Re: How can I split cells in Numbers 3.0.1
    Nick-Thirteen Level 1 Level 1 (0 points)

    Thanks SG

     

    But I meant splitting cells that have not been merged. I would like to add cells in a row that were not previously there - as you could in the previous version of Numbers.  It was so simple and so very useful - greatly missed !

     

    Nick

  • 4. Re: How can I split cells in Numbers 3.0.1
    Nick-Thirteen Level 1 Level 1 (0 points)

    Thanks Jerry


    I feared as much - I thought Numbers 3.0.1 was supposed to be a step forward, not backward .....

     

    Nick

  • 5. Re: How can I split cells in Numbers 3.0.1
    SGIII Level 5 Level 5 (4,135 points)

    Hi Nick,

     

    I'm curious about this. Could you give a simple example?  I always just insert rows or columns when I need them, knowing that tables in spreadsheets generally work best as a simple grid.

     

    SG

  • 6. Re: How can I split cells in Numbers 3.0.1
    Nick-Thirteen Level 1 Level 1 (0 points)

    I often want to add some sub-cells within a row rather than a new full row, as the example attached.  I have split in the previous version of Numbers the cell to the left of the highlighted cell.  I would very much like to do this in the latest Numbers

     

    Nick

     

     

    Numbers 301.jpg
  • 7. Re: How can I split cells in Numbers 3.0.1
    SGIII Level 5 Level 5 (4,135 points)

    Nick,

     

    Interesting.  Thanks.

     

    What's the advantage of doing it that way rather than keeping things simple and uniform with the usual tables?

     

    (I suspect it would disable filtering and sorting, which can be so useful in tables.)

     

    Is this mainly to arrange things for display or print?

     

    SG

  • 8. Re: How can I split cells in Numbers 3.0.1
    Nick-Thirteen Level 1 Level 1 (0 points)

    Yes SG I like to keep things simple and clean

     

    But I record my commissions normally as one per row, but if the commission runs over two or more days I want to keep details of each day separate whilst under the same commission heading.  Therefore one row then contains two or more sub-sets of information.  It saves repeating / doubling up on the headings and other common details of the commission

     

    I suppose the backward way round the problem is to create two rows and merge common cells - but this will cause more work for me in general, and begs the question why remove a previoulsy available option !

     

    Nick

  • 9. Re: How can I split cells in Numbers 3.0.1
    SGIII Level 5 Level 5 (4,135 points)

    Hi Nick,

     

    Got it. The purer "spreadsheet way" to avoid duplication of data would be to record commissions in a separate table, and extract the sums corresponding to each "heading" with a formula, something like this:

     

    Screen Shot 2013-12-04 at 3.17.18 PM.png

     

    The formula in D2, copy pasted down,  is:

     

             =SUMIF(Commissions::$A,$A2,Commissions::$C)

     

    This says, add up everything in column C of the Commissions table where the value in column A of the Commissions table is the same as the value in column A of this row.

     

    This takes a one-time setup (and you have to make sure the values in column A of both tables are consistent) but thereafter there are advantages.  Among them, you can sort and filter your transactions or your commissions to get different views.

     

    Splitting and merging cells in spreadsheets generally spells trouble, even in Numbers 2.3, though it sounds as if you've been lucky.

     

    SG

  • 10. Re: How can I split cells in Numbers 3.0.1
    Nick-Thirteen Level 1 Level 1 (0 points)

    Thanks SG

     

    That is very useful and I will give it a try, although I tend to keep more notes / text in my spreadsheet than numbers and values.  Mainly it is information I want to record plus a few costs and times, but always useful to have a few pointers to streamline things !

     

    Nick

  • 11. Re: How can I split cells in Numbers 3.0.1
    kmixsy Level 1 Level 1 (0 points)

    Has this issue been resolved? I still cannot find the split cell option...

     

    I have one table that has a column of dimensions with just a space between the values, ex: 15.25  17.5 

     

    I would like to split these into two cells...

     

    I have a million of them so cutting and pasting is really tedious and I feel like I am not using numbers to its fullest potential!

     

    please help

  • 12. Re: How can I split cells in Numbers 3.0.1
    Jerrold Green1 Level 7 Level 7 (28,995 points)

    KM,

     

    Your question is different from the title of the thread. Please post it as a new question. Your question is:

     

    I have a column with two values, separated by a space, in each row. How do I create 2 new columns with the first value in one column and the second value in another column?

     

    Jerry