Find, cut and paste in next column

[Amir18]

I have a list of perfumes like below in excel

<TABLE style="WIDTH: 311pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=415 x:str><COLGROUP><COL style="WIDTH: 311pt; mso-width-source: userset; mso-width-alt: 15177" width=415><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 311pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17 width=415>SEX IN THE CITY LOVE 3.3 OZ. PARFUM SPRAY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>SEX IN THE CITY KISS 3.3 OZ. PARFUM SPRAY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>SEX IN THE CITY LUST 3.3 OZ. PARFUM SPRAY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>SEX IN THE CITY LIGHT 3.3 OZ. PARFUM SPRAY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>ADIDAS FLORAL DREAM 1.6 FL. OZ. EAU DE TOILETTE SPRAY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>ADIDAS FRUITY RHYTHM 1.6 FL. OZ. EAU DE TOILETTE SPRAY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>ADIDAS PURE LIGHTNESS 1.6 FL. OZ. EAU DE TOILETTE SPRAY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>ADIDAS TROPICAL PASSION 1.7 FL. OZ. EAU DE TOILETTE SPRAY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>PURE SUNG 3.4 FL. OZ. EAU DE TOILETTE SPRAY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>SUNG FOREVER 4.2 FL. OZ. EAU DE PARFUM SPRAY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>SHI 3.4 FL. OZ. EAU DE TOILETTE SPRAY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>ALFRED SUNG 1.6 FL. OZ. EAU DE TOILETTE SPRAY</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>SHI 1.6 FL. OZ. EAU DE TOILETTE SPRAY</TD></TR></TBODY></TABLE>

I want to cut and paste the name of the perfume, size of the bottle(1.6, 1.7, 3.4) and type (EAU DE TOILETTE, PARFUME) in their respective columns

So the result should be like

SEX IN THE CITY LOVE | 3.3 | PARFUM SPRAY


Thanks in Advance

 

[sulakvea]

assuming the data sits in Column A...

these go into B1, C1, D1, respectively. and copied down:

formula for the name:
=LEFT(A1,FIND(" OZ. ",A1)-5)

formula for the ounce:
=MID(A1,FIND(" OZ. ",A1)-3,3)

formula for the type:
=RIGHT(A1,LEN(A1)-FIND(" OZ. ",A1)-4)