Hi there,

I need the function which helps to concatenate the cell values which is separated by comma as follows:

If cell J5 ------> A1,B1,AB1....etc which needs to be converted as follows in to cell M5

<categ no = "A1"/><categ no = "B1"/><categ no = "AB1"/> etc....

Can you please anyone help me out on this?

thanks
Ganesan. G