I have a problem with an if formular. Individually it works for me, but not together. Can You help me?



=WENN(ISTZAHL(SUCHEN("PK";GLÄTTEN($E5)));LINKS((TE XTNACH(GLÄTTEN($E5);"PK";1));4)*1;WENN(ISTZAHL(SUC HEN("KR";GLÄTTEN($E5)));LINKS((TEXTNACH(GLÄTTEN($E 5);"KR";1));4)*1))

individually:

=WENN(ISTZAHL(SUCHEN("PK";GLÄTTEN($E5)));LINKS((TE XTNACH(GLÄTTEN($E5);"PK";1));4)*1)

=WENN(ISTZAHL(SUCHEN("KR";GLÄTTEN($E5)));LINKS((TE XTNACH(GLÄTTEN($E5);"KR";1));4)*1)

Next Problem is, I would like to have the 4-string Number or 3-string Number behind the "PK" or "PKR"

Is it possible?

Attached Files

Test1.xlsx (11.2 KB, 4 views)