I’m trying to extract a numbering sequence in an excel spreadsheet, but I don’t know how to do that. This specific numbering is in the middle of other words and other numbers that will not be used.
I want to extract all the numbers starting with 531 or 553. The numbering that starts with 531 has 10 more numbers totaling 13 numbers. The numbering starting with 553 has 11 more numbers totaling 14 numbers.
These numbers are in each row of a column in excel. The problem is that, often, these numbers are accompanied by other texts or other numbers such as date of birth, license plate, date of sending file, document numbering, etc. There is no pattern.
These numbers can also be separated with blanks or periods and dashes.
Can someone help me?