Excel 2007 : Insert comma to text string

Hi Guys

I want to insert comma at the end of every word/text string in a cell

A
1 WordX
2 Word Bx
3 WordZz

Will be like this:

A
1 WordX,
2 Word Bx,
3 WordZz,

I'm using the =CONCATENATE(A1,",")
to solve that problem,
Yet, is there a better way to do that?

I also need the macro to do the action on all the cells in column A
till it find an empty cell, then its stops.

Many thanks in advance.

Hi,

How about

=A1&","

Then double click the little black square in the bottom right hand corner of B1, this will auto-fill down provided you have your text in column A

Hi oldchippy

I didn't knew about "Double click the little black square..."

That solved the problem!

You da Man!!


Thanks.

Glad it helped - thanks for the feedback