I think a User Defined Function (UDF) is the way to go
Someone probably has a long complicated worksheet formula that does the same, but I prefer a UDF
ASSUMING that the Part number or whatever you want to extract has the same structure
Capture.JPG
Option Explicit
Function ExtractPart(s As String) As String
Dim v As Variant
Dim i As Long
ExtractPart = Empty
v = Split(s, " ")
For i = LBound(v) To UBound(v)
v(i) = UCase(Trim(v(i)))
If Len(v(i)) = 11 Then
If v(i) Like "[A-Z][A-Z]#########" Then
ExtractPart = v(i)
Exit Function
End If
End If
Next i
End Function