=SUBSTITUTE(TRIM(SUBSTITUTE(A2&",",B2&",","")),",","",LEN(A2)-LEN(SUBSTITUTE(A2,",","")))
<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:196px;" /><col style="width:179px;" /><col style="width:245px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td >*</td><td >A</td><td >B</td><td >C</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td >Raw Data</td><td >Already Data Present</td><td >Required Result</td></tr><tr style="height:36px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td >Shastri Market,Mohan Cinema</td><td >Mohan Cinema</td><td >Shastri Market</td></tr><tr style="height:36px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td >SCO.2 & 3, Sector-65/A, Phase-11, Near Punjab Mandi Board</td><td >Sector-65/A</td><td >SCO.2 & 3, Phase-11, Near Punjab Mandi Board</td></tr><tr style="height:36px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Birla Road, Near Vardhman Factory, Solan, Near Abbott</td><td >Birla Road</td><td >Near Vardhman Factory, Solan, Near Abbott</td></tr><tr style="height:73px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td >LH Electronics, Near Gurudwara Guru Aanad Dev, Janakpuri Vilas Park, Near Street No -11</td><td >Janakpuri Vilas Park</td><td >LH Electronics, Near Gurudwara Guru Aanad Dev, Near Street No -11</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C2</td><td >=SUBSTITUTE(TRIM<span style=' color:008000; '>(SUBSTITUTE<span style=' color:#0000ff; '>(A2&",",B2&",","")</span>)</span>,",","",LEN<span style=' color:008000; '>(A2)</span>-LEN<span style=' color:008000; '>(SUBSTITUTE<span style=' color:#0000ff; '>(A2,",","")</span>)</span>)</td></tr><tr><td >C3</td><td >=SUBSTITUTE(TRIM<span style=' color:008000; '>(SUBSTITUTE<span style=' color:#0000ff; '>(A3&",",B3&",","")</span>)</span>,",","",LEN<span style=' color:008000; '>(A3)</span>-LEN<span style=' color:008000; '>(SUBSTITUTE<span style=' color:#0000ff; '>(A3,",","")</span>)</span>)</td></tr><tr><td >C4</td><td >=SUBSTITUTE(TRIM<span style=' color:008000; '>(SUBSTITUTE<span style=' color:#0000ff; '>(A4&",",B4&",","")</span>)</span>,",","",LEN<span style=' color:008000; '>(A4)</span>-LEN<span style=' color:008000; '>(SUBSTITUTE<span style=' color:#0000ff; '>(A4,",","")</span>)</span>)</td></tr><tr><td >C5</td><td >=SUBSTITUTE(TRIM<span style=' color:008000; '>(SUBSTITUTE<span style=' color:#0000ff; '>(A5&",",B5&",","")</span>)</span>,",","",LEN<span style=' color:008000; '>(A5)</span>-LEN<span style=' color:008000; '>(SUBSTITUTE<span style=' color:#0000ff; '>(A5,",","")</span>)</span>)</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span>