How can I split one cell into two cells within a column in Numbers v3.2.2?

Question

How can I split one cell into two cells within a column in Numbers v3.2.2?

iMac, OS X Mavericks (10.9)

Posted on Jul 28, 2015 4:58 AM

Reply

Answer 1

Yellowbox

Level 7

20,383 points

Jul 28, 2015 7:40 AM in response to custom_install

Hi custom_install,

In Numbers, you can use the functions FIND, SEARCH, LEFT, MID and RIGHT to split data.

What are you trying to do? More information will lead to a solution 🙂.

Regards,

Ian.

Reply

Answer 2

Jul 28, 2015 6:10 AM in response to custom_install

you cannot split cells. You can, however merge other cells.

Review the information in this previous thread:

Re: What happened to the split cell feature in Numbers?

Reply

Answer 3

t quinn

Level 5

7,043 points

Jul 28, 2015 7:23 AM in response to custom_install

Hi custom_install,

You should be aware that merging cells can lead to difficulties esp. with sorting.

quinn

Reply

Answer 4

Csound1

Level 9

59,973 points

Jul 28, 2015 7:26 AM in response to custom_install

custom_install wrote:

How can I split one cell into two cells within a column in Numbers v3.2.2?

If you wish to convert cells contains data into two (or more) cells consider not using Numbers, Excel (and free apps such as Libre) can do what you want (Data to Columns command) based on criteria that you enter.

Reply