Given this data in A1:A5:
<TABLE style="WIDTH: 191pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=255 border=0 x:str><COLGROUP><COL style="WIDTH: 191pt; mso-width-source: userset; mso-width-alt: 9325" width=255><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; WIDTH: 191pt; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=255 height=17>LAXMI GANPATI ENTERPRISES19.475</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>19.45LAXMI GANPATI ENTERPRISES</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>116.39YOCHIT IMPEX</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>216.385KESHAV OILS & FOODS116.385</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>216.385KESHAV 116.385</TD></TR></TBODY></TABLE>
Try the following formulas:
B1 =IF(ISNUMBER(LEFT(A1)+0),LOOKUP(9.9E+307,--LEFT(A1,ROW($1:$99))),"")
C1 =REPLACE(REPLACE(A1,LEN(A1)-LEN(D1)+1,LEN(D1),""),1,LEN(B1),"")
D1 =IF(ISNUMBER(RIGHT(A1,1)+0),MID(REPLACE(A1,1,LEN(B1),""),MATCH(TRUE,INDEX(ISNUMBER(--MID(REPLACE(A1,1,LEN(B1),""),ROW($1:$99),1)),),FALSE),255)+0,"")
copied down.