Extracting text from a cell

[Partsguy100]

I have a long description in my item master and want to extract the first string after the number 205 in the description. I understand the logic by following other examples but can't get it to work.


Here is the long description that is essentially a big text box. I formatted the text to at least have the numbers on the left side, but even that is hit and miss as the wrap text formatting must be selected.

[TABLE="width: 642"]
<tbody>[TR]
[TD="class: xl63, width: 642"]000 1113567 EA N
060 WASHER PLAIN 33/64 IN ID X 15/16 IN OD X 1/16 IN THK
205 6101229 GM DIESEL

I would like to extract the number 6101229

BONUS: how can I format the cell the wrap around the numbers?


Please help!![/TD]
[/TR]
</tbody>[/TABLE]

 

[Rick Rothstein]

I get a #VALUE ! error when I used this formula

When I copy/paste what you posted in Message #8 , the formula I posted worked fine, so there must be something about you data that got "lost" when you posted it. Can you post a copy of the workbook where my formula fails to DropBox so I can look at your real data and try and trace where the problem is?