Pasting text in Numbers to have multiple rows?

Discussion in 'iWork Forum' started by DrHouse, Sep 18, 2011.

  1. DrHouse
    Offline

    DrHouse iPad Junkie

    Joined:
    Jan 17, 2011
    Messages:
    644
    Thanks Received:
    21
    Trophy Points:
    0
    Location:
    Quebec
    Ratings:
    +21 / 0
    Hi,

    I was wondering if there is a way to paste text containing linefeed into Numbers so it would create rows instead of pasting all the text in a single cell?

    I know I can do this in Excel or Calc on a pc, but I could not find a way to do it in Numbers on the iPad, without having to go to a computer.

    For example:

    Item1
    Item2
    Item3

    Selection the 3 words, including line feeds, and pasting in Numbers will result in a single cell containing the whole text. What I want is having rows A, B, C to have one word for each...

    I ended up doing the pasting one word at a time, but it's time consuming...

    Thanks!

    VicoPad addict!
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,827
    Thanks Received:
    2,225
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,651 / 1
    You can change the file suffix on a txt file to .csv and import to Numbers. This will result in a column for every comma, and a new row for every linefeed. You can then copy&paste the resulting table cells from the new document to the document you want them in.

    That's the closest I can come to what you want.
  3. DrHouse
    Offline

    DrHouse iPad Junkie

    Joined:
    Jan 17, 2011
    Messages:
    644
    Thanks Received:
    21
    Trophy Points:
    0
    Location:
    Quebec
    Ratings:
    +21 / 0
    That's what I had in mind, by putting the file in dropbox. But goodreader did not let me change the suffix, nor dropbox itself... There is surely an app that would let me change the extention of the file, but I could not find one.

    I'll keep looking, and will post the workaround when I find one. I'm a bit disapointed that Numbers does not support a "paste special"...

    Thanks

    VicoPad addict!
  4. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,827
    Thanks Received:
    2,225
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,651 / 1
    I've used GoodReader to change suffixes before. Use the Rename button in the Manage Files section. If the old suffix does not show, add the new one and it will ask whether you want to chane the file type or not.
  5. DrHouse
    Offline

    DrHouse iPad Junkie

    Joined:
    Jan 17, 2011
    Messages:
    644
    Thanks Received:
    21
    Trophy Points:
    0
    Location:
    Quebec
    Ratings:
    +21 / 0
    I figured it out... Thanks for your tip. I had already tried renaming the file with GoodReader, but when I saw ".txt hidden", I stopped there thinking that it would not allow me to change the extention and would end up with file.csv.txt...

    So I tried again and renamed the file "file.csv" and GoodReader asked me if I wanted to change the extension, which I did. And voila! A csv file that can be imported in Numbers...

    Darn! I was one click away of the solution ;).

    You're a genius!

    VicoPad addict!
  6. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,827
    Thanks Received:
    2,225
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,651 / 1
    Nah, someone else had almost the same problem/solution a couple months ago. You must have missed the thread. :)
  7. DrHouse
    Offline

    DrHouse iPad Junkie

    Joined:
    Jan 17, 2011
    Messages:
    644
    Thanks Received:
    21
    Trophy Points:
    0
    Location:
    Quebec
    Ratings:
    +21 / 0
    Maybe... I did googled but I always found articles about importing a csv or on how to paste tables into Numbers... Surely it was there somewhere, buried under csv files, tables and excel graphics ;)

    VicoPad addict!
  8. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    16,827
    Thanks Received:
    2,225
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,651 / 1
    Probably. I'd hate to try and find it myself, and I remember just enough to narrow it down further than you would have. ;)

Share This Page

Search tags for this page

.csv

,
apple numbers how to paste into rows
,
csv column not row numbers iwork
,
how do i paste special in numbers in imac
,
how to copy and paste multiple rows in numbers 09
,
how to copy paste text to numbers mac
,

how to paste a list into numbers

,
ipad numbers app selecting multiple cells
,
mac numbers paste text
,
mac numbers paste text into cell
,

numbers paste csv

,

past list into numbers

,
paste data into numbers
,
paste data to mac numbers
,
paste multiple into numbers 09
,
paste multiple lines into numbers
,

paste special in apple numbers

,

paste text in numbers mac

,

pasting text into numbers

,
text to rows in iwork