Text field may contain a 5 digit code, and if so need to extract it to its own column

So my title data sometimes contains a code that tells me important information about the item, my ultimate goal is to use this code with a vlookup function to autofill other fields. My problem is tha...