Try:


="<opt mfr="""&LEFT(L5,FIND(CHAR(10),L5)-1)&""" pnv="""&LEFT(K5,FIND(CHAR(10),K5)-1)&"""/>" &CHAR(10)&"<opt mfr="""&MID(L5,FIND(CHAR(10),L5)+1,255)&"""pnv="& MID(K5,FIND(CHAR(10),K5)+1,255)&"""/>"


copied down




Format the result cells by Wrapping text

Thanks for the reply

Can you please help me more on this.... as follow


if i have the data like

in cell k have three values and cell l one value how can call cell l value to all cell k values

"<opt mfr=""09021"" pnv=""RK73H2HL **4991F""/>
<opt mfr=""09021""pnv=CRCW20104K99FKTF""/>"

also i have the values in cell K sometimes more than one, in this case will take cell l value