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

MP123 · May 21, 2014

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?

lucasbraydon · May 21, 2014

Yeh press it faster

SavageX · May 21, 2014

=concatenate(a1, ",")

RockstarSEO · May 21, 2014

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

MP123 · May 21, 2014

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

Deleted member 36594 · May 21, 2014

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".

theonly1 · May 21, 2014

Or in MS Word:
Ctrl+F
For find type: ^p
For replace with type: ,

arpitagarwal82 · May 21, 2014

http://textmechanic.com/Add-Prefix-Suffix-to-Text.html

Just use this

SavageX · May 21, 2014

MP123 said:
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

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

MP123 · May 21, 2014

I bloody love you guys! thanks a lot

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

retro · May 21, 2014

im usually using gsa ser,spin sintax converter and convert to comma spin, that was very fast for me

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

MP123

Junior Member

lucasbraydon

Supreme Member

SavageX

Junior Member

RockstarSEO

Power Member

MP123

Junior Member

Deleted member 36594

Guest

theonly1

BANNED FOR SPAM/FAKE REVIEWS

arpitagarwal82

Senior Member

SavageX

Junior Member

MP123

Junior Member

retro

Newbie

Main Menu

Marketplace

Making Money

BlackHat World