Calling for people who are excel experts

Discussion in 'BlackHat Lounge' started by rap8557, Sep 2, 2009.

  1. rap8557

    rap8557 Jr. VIP Jr. VIP

    Joined:
    Sep 15, 2008
    Messages:
    1,614
    Likes Received:
    539
    How can you code this?

    [​IMG]

    When you paste all emails on col A it will automatically arrange 5 emails per cell on col B.

    I really need this so that my Improvised gmail responder will be fully automated..

    thanks! :tee:
     
  2. rap8557

    rap8557 Jr. VIP Jr. VIP

    Joined:
    Sep 15, 2008
    Messages:
    1,614
    Likes Received:
    539
  3. Siek

    Siek Regular Member

    Joined:
    Feb 4, 2008
    Messages:
    456
    Likes Received:
    294
    Heres a start:

    Code:
    =A1&CHAR(10)&A2&CHAR(10)&A3&CHAR(10)&A4&CHAR(10)&A5
    Make sure you set columb B to "Wrap Text"
     
    • Thanks Thanks x 1
  4. rap8557

    rap8557 Jr. VIP Jr. VIP

    Joined:
    Sep 15, 2008
    Messages:
    1,614
    Likes Received:
    539
    ok another question how about the 2nd row? when you drag it down this is the code that comes out
    Code:
    =A2&CHAR(10)&A3&CHAR(10)&A4&CHAR(10)&A5&CHAR(10)&A6
     
    Last edited: Sep 3, 2009