Thread: [Solved] About converting
View Single Post
 
Old 11-26-2018, 12:33 AM
ganesang ganesang is offline Windows XP Office 2016
Competent Performer
 
Join Date: Jul 2018
Posts: 170
ganesang is on a distinguished road
Default

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.
Reply With Quote