Welcome to iPadForums.net Guest - Click Here to Register

Pasting text in Numbers to have multiple rows?

This is a discussion on Pasting text in Numbers to have multiple rows? within the iWork Forum forums, part of the iPad App Store category; 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 ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Results 1 to 8 of 8
  1. #1
    iPad Junkie
    Member #
    29813
    Liked
    21 times
    Join Date
    Jan 2011
    Location
    Quebec
    Posts
    644

    Pasting text in Numbers to have multiple rows?

    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!
    iPhone 4S 16Gigs 5.01
    iPad 1 16 Gigs Wifi 5.01
    Canada / Rogers

  2. Ads


  3. #2
    iPF Legend
    Member #
    28530
    Liked
    1522 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,430
    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.

  4. #3
    iPad Junkie
    Member #
    29813
    Liked
    21 times
    Join Date
    Jan 2011
    Location
    Quebec
    Posts
    644
    Quote Originally Posted by twerppoet
    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.
    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!
    iPhone 4S 16Gigs 5.01
    iPad 1 16 Gigs Wifi 5.01
    Canada / Rogers

  5. #4
    iPF Legend
    Member #
    28530
    Liked
    1522 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,430
    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.

  6. #5
    iPad Junkie
    Member #
    29813
    Liked
    21 times
    Join Date
    Jan 2011
    Location
    Quebec
    Posts
    644
    Quote Originally Posted by twerppoet
    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.
    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!
    iPhone 4S 16Gigs 5.01
    iPad 1 16 Gigs Wifi 5.01
    Canada / Rogers

  7. #6
    iPF Legend
    Member #
    28530
    Liked
    1522 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,430
    Nah, someone else had almost the same problem/solution a couple months ago. You must have missed the thread.

  8. #7
    iPad Junkie
    Member #
    29813
    Liked
    21 times
    Join Date
    Jan 2011
    Location
    Quebec
    Posts
    644
    Quote Originally Posted by twerppoet
    Nah, someone else had almost the same problem/solution a couple months ago. You must have missed the thread.
    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!
    iPhone 4S 16Gigs 5.01
    iPad 1 16 Gigs Wifi 5.01
    Canada / Rogers

  9. #8
    iPF Legend
    Member #
    28530
    Liked
    1522 times
    Join Date
    Jan 2011
    Location
    Walla Walla, WA
    Posts
    15,430
    Probably. I'd hate to try and find it myself, and I remember just enough to narrow it down further than you would have.


Home | Forum | Active Topics | What's New

Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. Pasting across columns in Numbers
    By Hal05154 in forum iWork Forum
    Replies: 4
    Last Post: 10-04-2012, 10:27 AM
  2. Pdf text search for multiple files
    By urazyjazzy in forum iPad Apps
    Replies: 0
    Last Post: 07-21-2011, 04:47 AM
  3. Copying and pasting from a website
    By Ginaellen in forum iPad Help
    Replies: 1
    Last Post: 06-05-2011, 10:15 AM
  4. How do you freeze rows or columns in Numbers?
    By drPr in forum iPad General Discussions
    Replies: 2
    Last Post: 04-13-2011, 01:52 PM
  5. Pasting to websites
    By James696 in forum iPad General Discussions
    Replies: 0
    Last Post: 11-07-2010, 10:22 AM

Search tags for this page

.csv
,
how to paste a list into numbers
,
numbers paste csv
,

past list into numbers

,
paste special in apple numbers
,
paste text in numbers mac
,

pasting text into numbers

,

text in numbers

Click on a term to search for related topics.