separate text

[OHIYO]

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 219px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 95px"><COL style="WIDTH: 40px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD>B.C.(604) 16042998302 22 0.396</TD><TD></TD><TD>B.C.(604)</TD><TD style="TEXT-ALIGN: right">16042998302</TD><TD style="TEXT-ALIGN: right">22</TD><TD style="TEXT-ALIGN: right">0.396</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD>Ontario 15192508677 11 0.198</TD><TD></TD><TD>Ontario </TD><TD style="TEXT-ALIGN: right">15192508677</TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">0.198</TD></TR><TR style="HEIGHT: 22px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>B.C.(604) 16042414832 2 0.036</TD><TD></TD><TD>B.C.(604)</TD><TD style="TEXT-ALIGN: right">16042414832</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">0.036</TD></TR></TBODY></TABLE>

Hi,

Please help how to separate the text in column A to column C,D,E,F as shown above?

ohiyo

 

[T. Valko]

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 219px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 95px"><COL style="WIDTH: 40px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD>B.C.(604) 16042998302 22 0.396</TD><TD></TD><TD>B.C.(604)</TD><TD style="TEXT-ALIGN: right">16042998302</TD><TD style="TEXT-ALIGN: right">22</TD><TD style="TEXT-ALIGN: right">0.396</TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD>Ontario 15192508677 11 0.198</TD><TD></TD><TD>Ontario </TD><TD style="TEXT-ALIGN: right">15192508677</TD><TD style="TEXT-ALIGN: right">11</TD><TD style="TEXT-ALIGN: right">0.198</TD></TR><TR style="HEIGHT: 22px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD>B.C.(604) 16042414832 2 0.036</TD><TD></TD><TD>B.C.(604)</TD><TD style="TEXT-ALIGN: right">16042414832</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">0.036</TD></TR></TBODY></TABLE>

Hi,

Please help how to separate the text in column A to column C,D,E,F as shown above?

ohiyo

Select the range of data
Goto Data>Text to Columns
Select Delimited>Next
Select Space
Finish

 

[OHIYO]

thank you for your help, i save a lot of time.

 

[T. Valko]

thank you for your help, i save a lot of time.

You're welcome. Thanks for the feedback!