Adding one character to the end of each entry in a column

**Lowman** · 05-24-2011, 05:51 AM

Hello, I am guessing that there is probably a really simple solution for this, but I am really struggling to figure it out...

In one column I have a list of serial numbers and I want to add a comma at the end of each entry without having to type it manually into each individual field.

So basically, I want it to go from this:

1234
4567
5678
6789

To this:

1234,
4567,
5678,
6789,

This is because I have to then copy these serial numbers into another program for running searches, but for it to work properly, each serial needs a comma between. And there are literally 1000s of them, so I am trying to find a way to save time.

If anyone can help, that would be fantastic!

**abousetta** · 05-24-2011, 06:06 AM

Hello,

Simplist solution is to use a second column and add this formula to it:

Please Login or Register  to view this content.

OR

Please Login or Register  to view this content.

Now if you need to actually replace the original cell contents then you will need vba.

abousetta

**TMS** · 05-24-2011, 06:08 AM

You can do this with a Helper column.

For the sake of argument, let's assume your data is in column A and starts in row 2 allowing for a header. Also that we can put a formula in column B ... but it can be anywhere.

In cell B2, put the formula: =A2&"," and drag this down to the end of your data.

Select all the formulae in column B and copy it. Select cell A2 and do Paste Special | Values. Then delete the formulae in column B.

Done.

Regards

**abousetta** · 05-24-2011, 06:24 AM

If you need to replace the original cell contents with the new ones. This vba code should do it:

Please Login or Register  to view this content.

abousetta

**Lowman** · 05-24-2011, 07:13 AM

Thank you guys very much! Problem now solved!

I knew it would be something fairly straight forward!

**TMS** · 05-24-2011, 07:15 AM

You're welcome.

If this has addressed your question, please mark your thread as solved. See my signature for details or the FAQ.

Regards

**abousetta** · 05-24-2011, 07:16 AM

Hi,

Glad we could be of assistance. If you are satisfied with the results, please mark the thread as [SOLVED] (next to the title on the first post). Also positive recognition (scales) are always welcomed .

If want to mark the post as solved then:

1) Click the Edit button on your first post in the thread
2) Click Go Advanced
3) select [SOLVED] from the Prefix dropdown
4) click Save Changes

Good luck.

abousetta