using Find and splitting text

[monsierexcel]

i have the string "

Small Parcel Box Royal Mail Postal Box A4 310mm x 230mm x 150mm Diecut" I want to pull the text "310mm x 230mm x 150mm" i can use Find and Right to pull the first mm and extract specifc level of characters but im not sure how to pull the whole string so the first space before 310mm until the last mm after 150? Hope someone is clever with cutting these out in formula! thank you all,

<colgroup><col width="571"></colgroup><tbody>
</tbody>

 

[Fluff]

I'm afraid I don't understand.
3 of those 4 strings are already what you said you wanted.

 

[monsierexcel]

Hi Fluff, sorry to quote a full string it could be anything within there
so
"blah blah blah 400mm x 20mm x 30mm blah blah"
"test 400mm x 200mm x 300mm test test test"

 

[Fluff]

Dante's formula already does that

Excel 2013/2016
	A	B
2	Small Parcel Box Royal Mail Postal Box A4 310mm x 230mm x 150mm Diecut	310mm x 230mm x 150mm
3	blah blah blah 400mm x 20mm x 30mm blah blah	400mm x 20mm x 30mm
4	test 400mm x 200mm x 300mm test test test	400mm x 200mm x 300mm
Log

Cell Formulas
Range	Formula
B2	=TRIM(MID(SUBSTITUTE(A2," ", REPT(" ",250)),SEARCH("mm",SUBSTITUTE(A2," ", REPT(" ",250)))-50,250*5))

 

[monsierexcel]

thank you both thats ace.

 

[Fluff]

Glad we could help & thanks for the feedback

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.