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)

Take a look at column K in the attached:
It works for all of your sample data but do test it more thoroughly.


ps. You seem to be one (of many) people who only acknowledge past help when they need more help.

Attached Files

MSOfficeForums_Test1.xlsx (12.4 KB, 0 views)

Couldn't have put it better

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post