I am looking to query some variables in Excel using a formula. I have a database that has some IDs in it that I need pulled out. The problem is that the IDs vary in length and type.
Here are some examples of the database, bare with me:
Identification Key: ID000012 DESCRIPTION: DO this here in terms of company policy.
Identification version 5.1.1 Audit ID: 11123
ID: A-12345 Description: DeltaDelta - Download ASAP
See how the IDs all differ just slightly but I'm wanting to pull basically the same information out of each. Is there a formula that can be written to encompass finding "ID000012", "11123" and "A-12345" all these in one?
These are just variables, there are thousands of IDs that I need to pull but I figured giving real life examples would make it easier to see what I'm trying to do here.
Any help greatly appreciated!