Unable to split columns in tables
Unable to split columns in tables.
Help please?
Unable to split columns in tables.
Help please?
The only thing I can guess from this is that you MAY be in a spreadsheet - but text editors do tables too sometimes...
Tell us a Story - with a beginning, a middle and end. We need to understand everything that you know and have experienced.
If this issue is new, tell us what immediately preceded its onset - add software, upgrade or update? New equipment?
Quoted from Apple's "How to write a good question"
To help other members answer your question, give as many details as you can.
For a detailed "coaching", please see the User Tip > "Help us to help you on these forums"<https://discussions.apple.com/docs/DOC-5431>
"Keep It Short and Simple" - Take your time... but be thorough - ÇÇÇ
Hi Corinne,
If you are using the Numbers app, you can split a column if there are consistent 'split points' in each cell. Then you can use the LEFT, MID or RIGHT functions to pull data into other columns. Hint: type = in a spare cell to bring up the Function Panel, and type the name of a function in the Search Box for help.
Adding to ÇÇÇ's advice, a screen shot of a small part of your Numbers table will tell the story.
Please reply with a screen shot of a small part of your screen (command shift 4 and drag). Full screen shots (command shift 3) are often difficult to read.
Wayne Contello has written a User Tip on how to post a screen shot.
https://discussions.apple.com/docs/DOC-6591
Regards,
Ian.
If you mean splitting a single column into two columns, this feature does not exist in Numbers directly. to get the same effect refer to the table below:
If I understand your question you would like, for instance, for cell A1 to become two cells. To achieve this:
- add a new column after column A
Column B is the "new" column
now select cells A1 and B1,
then select the menu item "Table > Merge Cells"
Just so you know... merging cells causes problems with sorting... proceed with caution
Unable to split columns in tables