B1 : =LEFT(A1,FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))-1) C1 : {=MID(RIGHT(A1,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A1,4),COLUMN(1:1),1)*1),0),LEN(RIGHT(A1,4)))} C2 : {=MID(RIGHT(A2,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A2,4),COLUMN(2:2),1)*1),0),LEN(RIGHT(A2,4)))} B3 : =LEFT(A3,FIND("#",SUBSTITUTE(A3," ","#",LEN(A3)-LEN(SUBSTITUTE(A3," ",""))))-1) C3 : {=MID(RIGHT(A3,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A3,4),COLUMN(3:3),1)*1),0),LEN(RIGHT(A3,4)))} B4 : =LEFT(A4,FIND("#",SUBSTITUTE(A4," ","#",LEN(A4)-LEN(SUBSTITUTE(A4," ",""))))-1) C4 : {=MID(RIGHT(A4,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A4,4),COLUMN(4:4),1)*1),0),LEN(RIGHT(A4,4)))} B5 : =LEFT(A5,FIND("#",SUBSTITUTE(A5," ","#",LEN(A5)-LEN(SUBSTITUTE(A5," ",""))))-1) C5 : {=MID(RIGHT(A5,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A5,4),COLUMN(5:5),1)*1),0),LEN(RIGHT(A5,4)))} B6 : =LEFT(A6,FIND("#",SUBSTITUTE(A6," ","#",LEN(A6)-LEN(SUBSTITUTE(A6," ",""))))-1) C6 : {=MID(RIGHT(A6,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A6,4),COLUMN(6:6),1)*1),0),LEN(RIGHT(A6,4)))} B7 : =LEFT(A7,FIND("#",SUBSTITUTE(A7," ","#",LEN(A7)-LEN(SUBSTITUTE(A7," ",""))))-1) C7 : {=MID(RIGHT(A7,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A7,4),COLUMN(7:7),1)*1),0),LEN(RIGHT(A7,4)))} B8 : =LEFT(A8,FIND("#",SUBSTITUTE(A8," ","#",LEN(A8)-LEN(SUBSTITUTE(A8," ",""))))-1) C8 : {=MID(RIGHT(A8,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A8,4),COLUMN(8:8),1)*1),0),LEN(RIGHT(A8,4)))} B9 : =LEFT(A9,FIND("#",SUBSTITUTE(A9," ","#",LEN(A9)-LEN(SUBSTITUTE(A9," ",""))))-1) C9 : {=MID(RIGHT(A9,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A9,4),COLUMN(9:9),1)*1),0),LEN(RIGHT(A9,4)))} B10 : =LEFT(A10,FIND("#",SUBSTITUTE(A10," ","#",LEN(A10)-LEN(SUBSTITUTE(A10," ",""))))-1) C10 : {=MID(RIGHT(A10,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A10,4),COLUMN(10:10),1)*1),0),LEN(RIGHT(A10,4)))} B11 : =LEFT(A11,FIND("#",SUBSTITUTE(A11," ","#",LEN(A11)-LEN(SUBSTITUTE(A11," ",""))))-1) C11 : {=MID(RIGHT(A11,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A11,4),COLUMN(11:11),1)*1),0),LEN(RIGHT(A11,4)))} B12 : =LEFT(A12,FIND("#",SUBSTITUTE(A12," ","#",LEN(A12)-LEN(SUBSTITUTE(A12," ",""))))-1) C12 : {=MID(RIGHT(A12,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A12,4),COLUMN(12:12),1)*1),0),LEN(RIGHT(A12,4)))} B13 : =LEFT(A13,FIND("#",SUBSTITUTE(A13," ","#",LEN(A13)-LEN(SUBSTITUTE(A13," ",""))))-1) C13 : {=MID(RIGHT(A13,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A13,4),COLUMN(13:13),1)*1),0),LEN(RIGHT(A13,4)))} B14 : =LEFT(A14,FIND("#",SUBSTITUTE(A14," ","#",LEN(A14)-LEN(SUBSTITUTE(A14," ",""))))-1) C14 : {=MID(RIGHT(A14,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A14,4),COLUMN(14:14),1)*1),0),LEN(RIGHT(A14,4)))} B15 : =LEFT(A15,FIND("#",SUBSTITUTE(A15," ","#",LEN(A15)-LEN(SUBSTITUTE(A15," ",""))))-1) C15 : {=MID(RIGHT(A15,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A15,4),COLUMN(15:15),1)*1),0),LEN(RIGHT(A15,4)))} B16 : =LEFT(A16,FIND("#",SUBSTITUTE(A16," ","#",LEN(A16)-LEN(SUBSTITUTE(A16," ",""))))-1) C16 : {=MID(RIGHT(A16,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A16,4),COLUMN(16:16),1)*1),0),LEN(RIGHT(A16,4)))} B17 : =LEFT(A17,FIND("#",SUBSTITUTE(A17," ","#",LEN(A17)-LEN(SUBSTITUTE(A17," ",""))))-1) C17 : {=MID(RIGHT(A17,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A17,4),COLUMN(17:17),1)*1),0),LEN(RIGHT(A17,4)))} B18 : =LEFT(A18,FIND("#",SUBSTITUTE(A18," ","#",LEN(A18)-LEN(SUBSTITUTE(A18," ",""))))-1) C18 : {=MID(RIGHT(A18,4),MATCH(TRUE,ISNUMBER(MID(RIGHT(A18,4),COLUMN(18:18),1)*1),0),LEN(RIGHT(A18,4)))}
Enthält Matrixformel: Umrandende { } nicht miteingeben, sondern Formel mit STRG+SHIFT+RETURN abschließen! |