Return a variable text string to an ajacent cell

I have a large spreadsheet. Some of the cells contain order numbers in cells containing text. The order number is located in various positions within the cell. I am trying to retu the order number (alone) in the adjacent cell, to the cell containing the order number as part of the text.

Any help would be appreciated.