Array...

  • Thread starter Thread starter sab
  • Start date Start date
S

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
 
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))
 
Back
Top