Adding a comma?

[MN_Excel]

I have a search formula that is working perfectly except for the fact that it comes back with an error when the number it is looking for is the last number in a cell. For example, if I search a cell for C7 and the cell has data of C4, C5, C6, and C7 it won't find C7 b/c there isn't a comma after it, which I have as a argument in my formula. In short, does anyone know how to add a comma at the end of each cell in a column?

 

[Jeff Meyers]

One approach:

You can concatenate to append a , to each of your cells (using a helper column)
Then you could Copy and Paste Special Values from the helper column to your original column

Sheet1

	A	B
1	C4, C5, C6, and C7	C4, C5, C6, and C7,
2	B4	B4,
3	D6, D7	D6, D7,
4	A9, B3, and D1	A9, B3, and D1,
5	B2, C4, D6	B2, C4, D6,
6
7
8	------------------------	------------------------
9

<thead>
</thead><tbody>
</tbody>

Excel 2010

Worksheet Formulas Cell Formula B1 =+A1&"," B2 =+A2&"," B3 =+A3&"," B4 =+A4&"," B5 =+A5&"," <thead> </thead><tbody> </tbody>

<tbody>
</tbody>