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

Calling for people who are excel experts

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

  1. rap8557

    rap8557 Jr. VIP Jr. VIP Premium Member

    Joined:
    Sep 15, 2008
    Messages:
    1,081
    Likes Received:
    436
    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 Premium Member

    Joined:
    Sep 15, 2008
    Messages:
    1,081
    Likes Received:
    436
  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 Premium Member

    Joined:
    Sep 15, 2008
    Messages:
    1,081
    Likes Received:
    436
    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