I have Pages text delimited by commas and want to paste it into Numbers

The text is delimited by commas and I want to paste it into cells in one column. It looks like this:



Any help would be appreciated.


Thanks,


Rich

MacBook Air 11", 10.13

Posted on Jan 30, 2019 8:05 AM

Reply
Question marked as Top-ranking reply

Posted on Jan 30, 2019 7:15 PM

If you want each word to be in its own cell, one way to do it is to paste it into TextEdit then do Find/Replace All, finding all ", " (comma with a space after it) and replacing it with a carriage return (use option-return to make a carriage return character). After that, look through it to make sure it all worked correctly. Manually fix any areas that did not go as planned. Finally, Select All, Copy, and Paste it into the first cell of your column in Numbers.

2 replies
Question marked as Top-ranking reply

Jan 30, 2019 7:15 PM in response to richman0841

If you want each word to be in its own cell, one way to do it is to paste it into TextEdit then do Find/Replace All, finding all ", " (comma with a space after it) and replacing it with a carriage return (use option-return to make a carriage return character). After that, look through it to make sure it all worked correctly. Manually fix any areas that did not go as planned. Finally, Select All, Copy, and Paste it into the first cell of your column in Numbers.

Jan 30, 2019 12:08 PM in response to richman0841

Hi Rich,


You should be able to:

  • Select all of the text
  • Copy
  • select the first cell (single click)
  • Paste


Here's the sample text I tested with:


In,, as, name, to, here, them, deny, wise, this, As, rapid, woody, my, he, me, which, Men, but, they, fail, shew, just, wish, next, put, Led, all, visitor, musical, calling, nor, her, Within, coming, figure, sex, things, are, Pretended, concluded, did, repulsive, education, smallness, yet, yet, described, Had, country, man, his, pressed, shewing, No, gate, dare, rose, he, Eyes, year, if, miss, he, as, upon, 




Unpleasant, nor, diminution, excellence, apartments, imprudence, the, met, new, Draw, part, them, he, an, to, he, roof, only, Music, leave, say, doors, him, Tore, bred, form, if, sigh, case, as, do, Staying, he, no, looking, if, do, opinion, Sentiments, way, understood, end, partiality, and, his, 




New, had, happen, unable, uneasy, Drawings, can, followed, improved, out, sociable, not, Earnestly, so, do, instantly, pretended, See, general, few, civilly, amiable, pleased, account, carried, Excellence, projecting, is, devonshire, dispatched, remarkably, on, estimating, Side, in, so, life, past, Continue, indulged, speaking, the, was, out, horrible, for, domestic, position, Seeing, rather, her, you, not, esteem, men, settle, genius, excuse, Deal, say, over, you, age, from, Comparison, new, ham, melancholy, son, themselves, 




Domestic, confined, any, but, son, bachelor, advanced, remember, How, proceed, offered, her, offence, shy, forming, Returned, peculiar, pleasant, but, appetite, differed, she, Residence, dejection, agreement, am, as, to, abilities, immediate, suffering, Ye, am, depending, propriety, sweetness, distrusts, belonging, collected, Smiling, mention, he, in, thought, equally, musical, Wisdom, new, and, valley, answer, Contented, it, so, is, discourse, recommend, Man, its, upon, him, call, mile, An, pasture, he, himself, believe, ferrars, besides, cottage, 


And here is the result, after following the four steps above:


e empty rows are due to the sample text having two returns entered to separate paragraphs. Your sample text appears to have several returns in the first section—the "Operations" words will likely be placed in six separate cells, with the last word in each cell being will, with, than, who, well, and yes.


When pasted, my words were displayed as a single line of words in each cell. Select the cells, click the Format brush, choose the Text section of the Inspector, and check the Wrap text in cell checkbox to display as shown above.


Regards,

Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

I have Pages text delimited by commas and want to paste it into Numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.