Hi, I have a long list of about 300 names just separated by line breaks. Is it possible to copy and paste into Numbers so they come out in separate cells?
Art the moment pasting just ends up in one long cell.
Many thanks in advance.
iMac 27″, macOS 10.15
Hi trevreav,
Perhaps you are clicking twice in a destination cell. That places the cursor inside that cell and paste will fill that cell with the whole copied list.
Click once on the destination cell and then paste.
Any improvement?
Regards,
Ian.
Hi trevreav,
Perhaps you are clicking twice in a destination cell. That places the cursor inside that cell and paste will fill that cell with the whole copied list.
Click once on the destination cell and then paste.
Any improvement?
Regards,
Ian.
Thanks Ian, that's exactly what it was. I use Numbers so rarely I forget these things! More of a graphic designer.
Thanks very much, you've saved me loads of hassle today.
Happy to help! 😊
Ian.
Paste a list into separate cells in Numbers
