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

NEED a bit EXCEL help!

Discussion in 'General Programming Chat' started by muusika, May 31, 2014.

  1. muusika

    muusika Junior Member

    Joined:
    Mar 2, 2012
    Messages:
    115
    Likes Received:
    10
    hi, how can i convert a list of names in a column
    to a rows with 6 names on each row?

    from this :
    vintagebless
    ceyceyl
    lisa4U
    lmack
    thefaschion
    lisafleurdelisa
    morinl1
    sizzerhappy418
    lisapatb
    TINJ
    lisaou11
    lisa_hasel
    +++++++++++++++++++++++++++++++++++++++++++++++++++++ to this: vintagebless ceyceyl lisa4U lmack thefaschion lisafleurdelisa morinl1 sizzerhappy418 lisapatb TINJ lisaou11 lisa_hasel
     
  2. Baraba

    Baraba Regular Member

    Joined:
    Jun 25, 2010
    Messages:
    436
    Likes Received:
    138
    Excel Concatenate.PNG You can use CONCATENATE function. Works even on very old Excel versions:
     
  3. Gogol

    Gogol Elite Member

    Joined:
    Sep 10, 2010
    Messages:
    3,063
    Likes Received:
    2,872
    Gender:
    Male
    Way in notepad++:

    Copy the column to notepad++ . Fireup replace screen by pressing ctrl + h -> select "search mode" as "regular expression" -> in find box enter [\r\n]{1,} and in replace box enter <space> ( type your spacebar once. don't copy this lol). > Click "replace all".

    Done :)