1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to do this in excel.

Discussion in 'BlackHat Lounge' started by Adapter, Jan 5, 2012.

  1. Adapter

    Adapter Newbie

    Joined:
    Jan 3, 2012
    Messages:
    12
    Likes Received:
    1
    Hello,

    Need some help with excel.

    Let's say I have a txt file with 3 lines.

    line1
    line2
    line3

    Ok, now, if I copy this into excel, it will show in 3 rows.

    What I want to do is, how do I make it stays in 1 row, but have 3 lines.So that, when I copy it back to the txt file, it will have 3 lines.

    You guys know how to do this ?

    Thanks
     
  2. t0m3313

    t0m3313 Regular Member

    Joined:
    Sep 11, 2011
    Messages:
    224
    Likes Received:
    56
    I think you have to mark the 3 fields you want the data in and then paste, this should work :) You know that row and line is the same, do you? ;)
     
  3. Adapter

    Adapter Newbie

    Joined:
    Jan 3, 2012
    Messages:
    12
    Likes Received:
    1
    No, that's not what I meant.

    I want column A and column B to corresponds.I have 100+ lines and I want row in column A and column B to corresponds.But, in column A, I have only 1 line, but in column B, I have 3 lines.When I copy the column B out and paste in notepad, I want it to show in 3 lines, not 1 line.

    I hope you get what I meant.

    Thanks
     
    Last edited: Jan 5, 2012
  4. CoyoteAssassin

    CoyoteAssassin Elite Member

    Joined:
    Jan 3, 2010
    Messages:
    1,862
    Likes Received:
    3,906
    Occupation:
    Full Time IMer
    Location:
    USA
    Do you mean that you want to turn

    line1
    line2
    line 3

    into...

    line1 line2 line3?

    If so, respond on here (not PM) and I can help. Let us know as it is not clear (to me).


    Make an example for us. You are not doing an excellent job of describing. Thanks.
     
    • Thanks Thanks x 1
  5. t0m3313

    t0m3313 Regular Member

    Joined:
    Sep 11, 2011
    Messages:
    224
    Likes Received:
    56
    Thanks, It was not really clear to me neither and still isnĀ“t :D
     
  6. m3ownz

    m3ownz Regular Member

    Joined:
    Dec 12, 2009
    Messages:
    311
    Likes Received:
    135
    Click the CELL you want it in, then click the function bar along the top (the long white bar you can type into). Then click paste. You will then have one cell containing 3 lines.

    Im 99% sure thats what you want.
     
  7. diablojump

    diablojump Newbie

    Joined:
    Jan 31, 2010
    Messages:
    49
    Likes Received:
    8
    In excel:
    - copy the list (one column, multiple rows)
    - select another cell, then select paste special, then select transpose.
    It should paste the multiple rows to multiple columns.
    I hope that what you meant.
     
  8. virtual.indiano

    virtual.indiano Regular Member

    Joined:
    Apr 24, 2011
    Messages:
    447
    Likes Received:
    470
    Location:
    Bhw
    Yeah copy and paste special with transpose option is what you are looking for.
     
  9. CoyoteAssassin

    CoyoteAssassin Elite Member

    Joined:
    Jan 3, 2010
    Messages:
    1,862
    Likes Received:
    3,906
    Occupation:
    Full Time IMer
    Location:
    USA
    I guess he isn't coming back. It sounds like using ASAP Utilities and transposing the text will do everything and more. I guess he found his answer...
     
  10. Adapter

    Adapter Newbie

    Joined:
    Jan 3, 2012
    Messages:
    12
    Likes Received:
    1
    Lol, actually I'm going back to using notepad (just for my work, not saying they do the same thing).
     
  11. CoyoteAssassin

    CoyoteAssassin Elite Member

    Joined:
    Jan 3, 2010
    Messages:
    1,862
    Likes Received:
    3,906
    Occupation:
    Full Time IMer
    Location:
    USA
    We are willing to help. We just need to know what you are asking for.

    If you, or anyone, doesn't already have it, I HIGHLY recommend you look into ASAP Utilities. It's been a lifesaver and allows me to do pretty much anything in Excel.

    Code:
    http://www.asap-utilities.com/
     
    • Thanks Thanks x 1