If formular (2 ifs) works alone, but not together

JanFr · #1 Today, 02:26 AM

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?

p45cal · #2 Today, 09:54 AM

Take a look at column K in the attached:

Code:

=INDEX(TEXTSPLIT(TRIM(INDEX(TEXTSPLIT(E2,{"PK","PKR"}),2)),{" ","-"}),1)

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merge documents;Formular with Checkboxes	Rekun	Word VBA	0	07-11-2018 11:51 AM
Date Range Formular	Colin C	Excel	5	04-22-2017 11:46 PM
Side view: Color of summary with formular interrupted	Mojo99	Project	5	10-07-2016 09:11 AM
I need to change a formular to overide formula	shanni11	Excel	1	09-10-2016 12:09 AM
Quick eplanation of formular	msheyworth	Excel	2	03-23-2013 11:43 AM