hi all how to separate a string:

[jamiguel77]

32443001[[[F\\Maria del Mar/Superior terminada,,15634311\Casado>Azul--S/ 10,133.00

i need separate, resultant:


[[[
\\
/
,,
\
>
--


32443001 F Maria del Mar Superior terminada 15634311 Casado Azul 10,133.00


any advice? thanks

 

[Fluff]

Can you please post both your text & expected result using the XL2BB add-in

 

[jamiguel77]

this is the text:

	Col 1	Col 2	Col 3	Col 4	Col 5	Col 6	Col 7	Col 8
32443001[[[F\\Maria del Mar/Superior terminada,,15634311\Casado>Azul--10,133.00	32443001	F	Maria del Mar	Superior terminada	15634311	Casado	Azul	10,133.00

ned use extract? or exist other way?
thanks

 

[Fluff]

Ok, how about

+Fluff 1.xlsm
	A	B	C	D	E	F	G	H	I
1		Col 1	Col 2	Col 3	Col 4	Col 5	Col 6	Col 7	Col 8
2	32443001[[[F\\Maria del Mar/Superior terminada,,15634311\Casado>Azul--10,133.00	32443001	F	Maria del Mar	Superior terminada	15634311	Casado	Azul	10,133.00
Lists

Cell Formulas
Range	Formula
B2	B2	=LEFT(A2,FIND("[",A2)-1)
C2	C2	=MID(A2,FIND("[[[",A2)+3,1)
D2	D2	=REPLACE(REPLACE(A2,FIND("/",A2),100,""),1,FIND("\\",A2)+1,"")
E2	E2	=REPLACE(REPLACE(A2,FIND(",,",A2),100,""),1,FIND("/",A2),"")
F2	F2	=REPLACE(REPLACE(A2,FIND("\",A2,FIND("\\",A2)+2),100,""),1,FIND(",,",A2)+1,"")
G2	G2	=REPLACE(REPLACE(A2,FIND(">",A2),100,""),1,FIND("\",A2,FIND("\\",A2)+2),"")
H2	H2	=REPLACE(REPLACE(A2,FIND("--",A2),100,""),1,FIND(">",A2),"")
I2	I2	=MID(A2,FIND("--",A2)+2,100)