Pasting from TextEdit to numbers spreadsheet

2014-09-15 Thread Andrew Lamanche
Dear Listers, Somebody once posted to the list on how one could paste text from TextEdit into Numbers spreadsheet. I have a number of lines with series of values in TextEdit which I would like to turn into a numbers table. How can I do this? I've tried to separate the number values with coma

Re: Pasting from TextEdit to numbers spreadsheet

2014-09-15 Thread Eugenia Firth
Hi Andrew You want to separate each column with tabs and then each row with a return. Commas won't work as far as I know. I've done this several times, and it works fine. Be sure to check, though, and make certain you didn't any tabs or cariage returns. Gigi On Sep 15, 2014, at 12:06 PM, An

Re: Pasting from TextEdit to numbers spreadsheet

2014-09-15 Thread Tim Kilburn
Hi, Separate each value with tabs in order to have them appear in different cells. This is accomplished reasonably quick and easy in TextEdit by using the Find/Replace functionality. For example, if you had previously place a comma between the values, then enter the comma in the Find field an

Re: Pasting from TextEdit to numbers spreadsheet

2014-09-15 Thread Andrew Lamanche
Dear Tim, This is greatly helpful. Thank you so much! Andrew On 15 Sep 2014, at 18:48, Tim Kilburn wrote: > Hi, > > Separate each value with tabs in order to have them appear in different > cells. This is accomplished reasonably quick and easy in TextEdit by using > the Find/Replace functi

Re: Pasting from TextEdit to numbers spreadsheet

2014-09-15 Thread Andrew Lamanche
Gigi, as usual, many thanks for a useful tip/. Fantastic! Andrew On 15 Sep 2014, at 18:34, Eugenia Firth wrote: > Hi Andrew > You want to separate each column with tabs and then each row with a return. > Commas won't work as far as I know. I've done this several times, and it > works fine. B