Numbers. I have copied a series of numbers as a block from the internet and want enter them separately into individual cells in a database. Currently they all go into the same cell when I paste in. Solution?
iMac (21.5-inch, Late 2013), OS X Yosemite (10.10.1)
Paste the text into a text editor and replace what ever separates the "cells" with a tab. , then select all, copy, then select the destination cell in a Numbers table, paste.
You can also post a representative sample of the data here for a more specific solution. Hard to guess without mores specifics.
Paste the text into a text editor and replace what ever separates the "cells" with a tab. , then select all, copy, then select the destination cell in a Numbers table, paste.
You can also post a representative sample of the data here for a more specific solution. Hard to guess without mores specifics.
Hi Wayne,
Worked a treat, will allow me to progress. Many thanks.
Wonder if there is formatting alternative?
Numbers. Multiple data entry
