D5:D12{=LEFT(TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(A$1,SMALL(IF(MID(SUBSTITUTE(A$1,"¤","-")&"-",ROW($1:$199),1)="-",ROW($1:$199)),ROW(A1))-2)," - ",),"",REPT(" ",199)),"¤",REPT(" ",199)),199)),MAX((MID(TRIM(RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(A$1,SMALL(IF(MID(SUBSTITUTE(A$1,"¤","-")&"-",ROW($1:$199),1)="-",ROW($1:$199)),ROW(A1))-2)," - ",),"",REPT(" ",199)),"¤",REPT(" ",199)),199)),ROW($1:$29),1)=" ")*ROW($1:$29)))
E5:E12{=RIGHT(TRIM(LEFT(REPLACE(A$1,SMALL(IF(MID(SUBSTITUTE(A$1,"¤","-")&"-",ROW($1:$199),1)="-",ROW($1:$199)),ROW(A1)),,REPT(" ",199)),199)),MATCH(1=1,LEFT(RIGHT(TRIM(LEFT(REPLACE(A$1,SMALL(IF(MID(SUBSTITUTE(A$1,"¤","-")&"-",ROW($1:$199),1)="-",ROW($1:$199)),ROW(A1)),,REPT(" ",199)),199)),ROW($1:$19)))=" ",)-1)
|