Array...

[sab]

Hi,

In range A1, i have:
name1; name2; name3; name4

Is' it possible to obtain (with a formula) in range B1:B4:
name1
name2
name3
name4

Thanks,
Sabine

 

[JE McGimpsey]

one way:

B1: =LEFT(A1,FIND(";",A1)-1)
B2: =TRIM(MID(A1,FIND(";",A1)+1, FIND("$", SUBSTITUTE(A1,";","$",2)) -
FIND(";",A1)-1))
B3: =TRIM(MID(LEFT(A1, FIND("$", SUBSTITUTE(A1,";","$",3))-1),
FIND("$", SUBSTITUTE(A1,";","$",2))+1,255))
B4: =TRIM(MID(A1, FIND("$", SUBSTITUTE(A1,";","$",3))+1,255))