Can anyone help me out on this?



I have explained detail as follows

I have the values which is separated by commas as follows,

for exam, Cell J5 contains J1 or J1,J2 or J1,D2,D3 and so on...

I need to convert this as in to the Cell S5 as,

<funcref="J1"/> or <funcref="J1"/><funcref="J2"/> or <funcref="J1"/><funcref="D2"/><funcref="D3"/> and so on....

Cell J5 sometime appears as empty. In this case retains as empty.

So whatever in the cell J5 needs to be converted within the coding (<funcref=" "/>) which is in each separated by commas.