Extracting specific numbers from field.

[PETERC086]

Please help.

I am trying to find a formula that will extract numbers from one field and separate into three fields
like my bad example below, i have one field with three numbers ie 300x600x9mm i need to have the three sets of numbers placed in each field. ie first number 300 in second field, second number 600 in third field and 3rd number in fourth field.

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
300 x 600 x 9mm 300 600 9

if any one has any ideas on how i could perform this task, it would be much appreciated. thanks

 

[Peter_SSs]

Re: Please Help, Extracting specific numbers from field.

If your sample data is representative then you could also use

=MID(A1,1+(LEFT(A1)="("),12)