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, 1 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

Many Thanks!!! It works perfect!!!

Unfortunately there is one Exception, I couldn't solve... for the most I have adjusted the nice formular....but does not work with: see attached file
could you please check? It's in Cell E26.

=WENNFEHLER((INDEX(TEXTTEILEN(GLÄTTEN(INDEX(TEXTTE ILEN(E26;{"PK"."PKR"."PKF"."AV"});2));{" "."-""("")"});1))*1;0), but this one I've adjusted is not correct...;-(

Attached Files

MSOfficeForums_Test1.xlsx (13.6 KB, 2 views)

Perhaps like the attached? ( you forgot some array delimiters)

Attached Files

MSOfficeForums_Test1.xlsx (13.6 KB, 2 views)

__________________
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

@Pecoflyer is right.
Just one thing; I'd be cautious about multiplying the result by 1 to return a number. Unless you're going to do arithmetical operations on these results I'd leave them as strings (you'd never do arithmetic on bank account numbers or debit/credit card numbers (except to check they're valid card numbers)).