Please help!

[bryantran]

Please help. I would like to seprate the string of data showed below to seperate columns (or to be exact, I just want to get the middle number starting with 6 in different column) but I don't know how. The problem is not all the strings are in the same format. Thanks so much for your help.
<TABLE style="WIDTH: 203pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=270><COLGROUP><COL style="WIDTH: 203pt; mso-width-source: userset; mso-width-alt: 9874" width=270><TBODY><TR style="HEIGHT: 30pt" height=40><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #e6e6e6; WIDTH: 203pt; HEIGHT: 30pt; BORDER-TOP: black 0.5pt solid; BORDER-RIGHT: black 0.5pt solid" class=xl66 height=40 width=270>409973/6565273/003545990</TD></TR><TR style="HEIGHT: 30pt" height=40><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 203pt; HEIGHT: 30pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 height=40 width=270>409973/6565273/003545991</TD></TR><TR style="HEIGHT: 30pt" height=40><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #e6e6e6; WIDTH: 203pt; HEIGHT: 30pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 height=40 width=270>419885/6565276/003545999</TD></TR><TR style="HEIGHT: 30pt" height=40><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 203pt; HEIGHT: 30pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 height=40 width=270>419885/6565276/003546000</TD></TR><TR style="HEIGHT: 30pt" height=40><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #e6e6e6; WIDTH: 203pt; HEIGHT: 30pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 height=40 width=270>419886/6565278/003546001</TD></TR><TR style="HEIGHT: 30pt" height=40><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 203pt; HEIGHT: 30pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 height=40 width=270>103165/6567046/003554960</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #e6e6e6; WIDTH: 203pt; HEIGHT: 15pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 height=20 width=270>6558290/3555462</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 203pt; HEIGHT: 15pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 height=20 width=270> </TD></TR><TR style="HEIGHT: 30pt" height=40><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #e6e6e6; WIDTH: 203pt; HEIGHT: 30pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 height=40 width=270>LOUIE RUNGE/6586318/003556727</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 203pt; HEIGHT: 15pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl64 height=20 width=270>6587181/3557004</TD></TR><TR style="HEIGHT: 30pt" height=40><TD style="BORDER-BOTTOM: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BACKGROUND-COLOR: #e6e6e6; WIDTH: 203pt; HEIGHT: 30pt; BORDER-TOP: black; BORDER-RIGHT: black 0.5pt solid" class=xl66 height=40 width=270>NS109/6585461/003557007</TD></TR></TBODY></TABLE>

 

[shg]

You could do Data > Text to columns, tick Delimited, and select / as the separator.

 

[jbeaucaire]

Highlight the column of data then use the Text To Columns feature to split the data. Select DELIMITED > Other Char: "/"