Text to Column using vba

[mrinal saha]

Hi folks,

Using text to column I want to segregate the data,but the alignment is a big trouble. Is there a way to identify and solution to this?

<TABLE style="WIDTH: 518pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=691 border=0><COLGROUP><COL style="WIDTH: 518pt; mso-width-source: userset; mso-width-alt: 25270" width=691><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 518pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" width=691 height=17>RUN DATE 07/23/11 PDBD133P-R01 REPORT FOR MAKE WHOLE CALLS PAGE:001</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>SEC # CUSIP # PRO-C DESCRIPTION-1 DESCRIPTION-2 DESCRIPTION-3</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>222MS6 09233YAC5 CORP BLACK ELK ENERGY 13.750% 120115 DTD060111 OFFSHORE CALL@MW+50BP</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>666D87 10588YAD7 CORN BRASKEM FIN LTD NTS B/E 05.750% 041521 DTD041511 FC101511 144A</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>444MR1 44447WAL3 CORN MORGAN STANLEY NTS B/E 05.500% 072821 DTD072811 FC012812</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>7777L2 888833AE2 CORN GRIFFON CORP NTS B/E 07.125% 040118 DTD031711 FC100111 144A</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17>7699L5 995112AL7 CBCV MICRON TECHNOLOGY INC 01.500% 080131 DTD072611 FC020112 NTS CONV 144A</TD></TR></TBODY></TABLE>


Thanks,
Mrinal Saha

 

[hiker95]

mrinal saha,

Can you post a screenshot of what the results should be (manually formatted by you)?

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these: