add comma to end of each cell

[rikpotts]

Sorry for my first post to be a question im sure has been asked a thousand times before; I dont know what to type into google to find my answer!

Ive got a list of image names, ie 1.jpg, 2.jpg etc in column A. All I want to do is search for these images on my hdd. Ive got a program which will do the search but it needs me to put a comma between each filename.

How can I add a comma to the end of each cell? I then plan on saving it as .csv or something then open it in notepad so I have a full list of the files I can copy and paste into my search program.

Hope someone can help! The mad thing is I did exactly this last year and have completely forgotten what to do!

Many Thanks
Rik

[oldchippy]

Sorry for my first post to be a question im sure has been asked a thousand times before; I dont know what to type into google to find my answer!

Ive got a list of image names, ie 1.jpg, 2.jpg etc in column A. All I want to do is search for these images on my hdd. Ive got a program which will do the search but it needs me to put a comma between each filename.

How can I add a comma to the end of each cell? I then plan on saving it as .csv or something then open it in notepad so I have a full list of the files I can copy and paste into my search program.

Hope someone can help! The mad thing is I did exactly this last year and have completely forgotten what to do!

Many Thanks
Rik

Hi Rik,

If A1 = 1.jpg

A2 = A1&","

Result = 1.jpg, then copy > paste special > values

oldchippy

[rikpotts]

Thanks for the reply. After days of tearing my hair out ive finally finished what I needed to do!

Many Thanks!!

[francijos]

brother,

Seek favor from you on a doubt of mine. 1 column and 1000 rows. each rows has a word. Now i need to add a comma at the end of each word. I see that you have answered to the same in a technical way. But brother can you pls explain to me in simple steps as to how do I do the same. I am kind of new to excel brother, so seeking the repetition in a elaborated way. pls mail me at [francijos at gmail dot com]

[arlu1201]

Francijos,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.