Extract Specific Text from cell

[king10001]

Hi Everyone

Have a cell with this in it

166.9 x 231.9 x 28.2mm | 716.68g

Have managed to extract 166.9 and 716.68g from it but need 231.9 and 28.2 extracted.

Used

=LEFT(F41,(FIND(" x ",F41,1)-1))

and

=MID(F41,FIND(" |",F41)+3,256)

Any suggestions please for the other two.

[Jonmo1]

Try this to extract all sections, assuming each secition is separated by either an x or |, and the original string lenth is less than 255 charactgers

A1 contains original string
in B1 and filled right as far as needed.
=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A1," x ",REPT(" ",255))," | ",REPT(" ",255)),(COLUMNS($A:A)-1)*255+1,255))

[AlKey]

Try this
enter in B1 and copy across

Please Login or Register  to view this content.

v	A	B	C	D	E
1	166.9 x 231.9 x 28.2mm | 716.68g	166.9	231.9	28.2	716.68