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
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.
SG
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
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
Thanks Jerry
I feared as much - I thought Numbers 3.0.1 was supposed to be a step forward, not backward .....
Nick
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
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
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
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
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:
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
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
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
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
How can I split cells in Numbers 3.0.1
