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

JanFr · #1 Yesterday, 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 Yesterday, 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
=SUM(MAXIFS formula works in some cells and not others	garymon9AX	Excel	2	02-28-2018 09:54 AM
Formula result not displaying in cell (but f9 works)	nath1235	Excel	4	10-06-2017 12:42 PM
Help with a formula which no longer works.	Silkwood	Excel	2	03-21-2017 02:25 PM
Formula works in Excel on my computer, but not on my PDA	Frenchy305	Excel	3	12-17-2015 08:33 AM
Formula works on most cells	gbaker	Excel	1	04-26-2014 12:31 AM