paste settings for Numbers - deliniating data

Question

Level 1

4 points

paste settings for Numbers - deliniating data

Hello, I am trying to work out how to paste in numbers so it sorts the data into different columns.

For example I have the following in text '89, 99, 107, 119, 127, 139, 149, 157' and I want to paste so each number ends up in its own column. I can see how to do this in excel (under text import settings click delineate by ,) but can't find any equivalent settings in numbers.

Hope this makes sense, if anyone could point me in the right direction it would be much appreciated. Thank you!

iMac 24″, macOS 13.3

Posted on May 24, 2023 7:09 AM

Reply

Answer 1

Top-ranking reply

SGIII

Level 8

37,920 points

May 24, 2023 8:32 AM in response to kellyb2104

Numbers will do this but when you paste it needs to see at least two lines of delimited text.

You could try adding a new line of text (if you don't have more data you could duplicate the first line.

89, 99, 107, 119, 127, 139, 149, 157

Select that, command-c to copy, click once in the cell of an existing table, and command-v to paste. The values should then be spread across different columns. You can then delete the second row if you don't need it.

SG

Reply

paste settings for Numbers - deliniating data

Similar questions