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

is there a quicker way to add a comma , after a name

Discussion in 'BlackHat Lounge' started by MP123, May 21, 2014.

  1. MP123

    MP123 Junior Member

    Joined:
    Nov 12, 2011
    Messages:
    163
    Likes Received:
    307
    Occupation:
    Go Play somewhere else, I'm busy!
    Location:
    Google it!!
    Hi,

    I have list of nearly 2000 names of people.

    I need to add a comma after every name, is there a trick I can do to do this for all the names? as it's becoming very time consuming doing this manually.

    For example names are like this.

    Joe Doe
    John Smith

    But I need them to be like this


    Joe Doe,
    John Smith,

    What is a quicker way of doing this?
     
  2. lucasbraydon

    lucasbraydon Supreme Member

    Joined:
    Nov 9, 2013
    Messages:
    1,244
    Likes Received:
    1,574
    Location:
    Here and there
    Yeh press it faster :D
     
    • Thanks Thanks x 1
  3. SavageX

    SavageX Junior Member

    Joined:
    Apr 5, 2014
    Messages:
    122
    Likes Received:
    30
    Location:
    UK
    =concatenate(a1, ",")
     
    • Thanks Thanks x 1
  4. RockstarSEO

    RockstarSEO Regular Member

    Joined:
    May 16, 2014
    Messages:
    474
    Likes Received:
    69
    Put up all the names in excel. Then in the 2nd (B2) column put a , then click the click and drag them till the end of the list.
    Or else PM it to me i could help you out :)
     
    • Thanks Thanks x 1
  5. MP123

    MP123 Junior Member

    Joined:
    Nov 12, 2011
    Messages:
    163
    Likes Received:
    307
    Occupation:
    Go Play somewhere else, I'm busy!
    Location:
    Google it!!
    Thanks guys!

    say I can now add , in excel...


    is there a way of quickly compiling the names so that it goes from

    Joe Doe,
    John Smith,

    To this

    Joe Doe,John Smith
     
  6. Sophie

    Sophie Jr. VIP Jr. VIP

    Joined:
    Mar 5, 2009
    Messages:
    2,062
    Likes Received:
    3,595
    Gender:
    Female
    Occupation:
       девушка
    Use notepad++

    Press CTRL + H > Replace

    Search mode: Extended.


    To add comma at the end:
    Find what: \r
    Replace with: ,


    To merge all of them in a line (e.g: Joe Doe, john Smith):
    Find what: \n
    Replace with:
    Yes, blank for "Replace With".
     
    • Thanks Thanks x 2
  7. theonly1

    theonly1 BANNED BANNED

    Joined:
    Nov 5, 2011
    Messages:
    219
    Likes Received:
    95
    Or in MS Word:
    Ctrl+F
    For find type: ^p
    For replace with type: ,
     
    • Thanks Thanks x 1
  8. arpitagarwal82

    arpitagarwal82 Power Member

    Joined:
    Feb 20, 2008
    Messages:
    726
    Likes Received:
    468
    Location:
    Localhost
    • Thanks Thanks x 1
  9. SavageX

    SavageX Junior Member

    Joined:
    Apr 5, 2014
    Messages:
    122
    Likes Received:
    30
    Location:
    UK
    Try this:

    do your commas first with concatenate, and then copy and paste as values.
    new cell formula: =TRANSPOSE - Highlight cells with comma, Dont click out of formula, press F9, formula changes to values, and then in formula bar change the formula to =CONCATENATE(values) - and delete the last comma if required. Then copy and paste as values again to use data
     
    • Thanks Thanks x 1
  10. MP123

    MP123 Junior Member

    Joined:
    Nov 12, 2011
    Messages:
    163
    Likes Received:
    307
    Occupation:
    Go Play somewhere else, I'm busy!
    Location:
    Google it!!
    I bloody love you guys! thanks a lot :D

    This is why I love BHW. All of you had a different method on doing it and all of em worked!

    Thank you so much, you just saved me hours of time and a nifty little trick to add to my skills
     
  11. retro

    retro Newbie

    Joined:
    Oct 17, 2008
    Messages:
    33
    Likes Received:
    5
    im usually using gsa ser,spin sintax converter and convert to comma spin, that was very fast for me