Text-functions with many criteria

[Javersoon]

Hallo everyone.

I have the following problem.
I am currently looking at a lot of ID's, and I need to be able to cross these ID's with other ID's.
For me to do that I need to extract som information from my ID's based on the ID's that I want to compare them with.

The problem is, that many of the ID's I am looking at have different attributes, so you cant just say fx =left(P2;6) and extract the same six digits. The Criteria is unique for each category of ID's.

Under here you will see the different ID categories, and what needs to be done in ordner for me to extract the information I need.
But how do I integrate every ID category in the corresponding formula into one big formula? How do I type all the different formulas under here into one single cell?

KON =IF(SEARCH("KON";P3)>0;LEFT(P3;FIND("-";P3)-1);"")
FIN =IF(SEARCH("FIN";P22)>0;LEFT(P22;FIND("-";P22)-1);"")
M2R =TRIM(IF(SEARCH("M2R";P92)>0;IFERROR(LEFT(P92;FIND("-";P92)-1);LEFT(P92;11));""))
DEB =IF(SEARCH("DEB";P22)>0;LEFT(P22;FIND("-";P22)-1);"")
DMI =TRIM(IF(SEARCH("DMI";P24)>0;IFERROR(LEFT(P24;FIND(" ";P24)-1);LEFT(P24;FIND("-";P24)-1));""))
KKO =IF(SEARCH("KKO";P3)>0;LEFT(P3;FIND("-";P3)-1);"")
ACL =IF(SEARCH("ACL";P492)>0;LEFT(P492;FIND("-";P492)-1);"")
MDI =IF(SEARCH("MDI";P535)>0;LEFT(P535;FIND("-";P535)-1);"")
XXXXXX-XXX LEFT(P483;10))

Kind regards!

[Squeaky]

My thoughts.
Go ahead and put each of these in a separate cell going across the row. You can always hide them. Whichever one is not = to "" can be picked up in another cell that will look at all the previous ones. You have 9 different formulas.
You can concatenate the results =concatenate(C2&d2&e2...) since all the other formulas resolve to "". There are any number of other formulas that can pull out the one that got answered, if any.