Hi folks,

I need the help to split values from cell values which separated using carriage-return/hard return as follows:

for instance, the cell contains like,

case 1: case 2:

cell K: cell L: or cell K: cell L:
abcd123785 53618 abcd123785 53618
bnsertsg1237 24515 bnsertsg1237

I need the conversion in other cell like,

case 1:
<opt mfr="53618" pnv="abcd123785"/>
<opt mfr="24515" pnv="bnsertsg1237"/>

case 2:
<opt mfr="53618" pnv="abcd123785"/>
<opt mfr="" pnv="bnsertsg1237"/>

Please help me out on this...

Thanks
ganesan. g

Attached Files

sample.xlsx (8.8 KB, 8 views)