Excel Formula - How to extract values between commas?

[YSWOO]

example

RANGE (A1) : AA, BB, CC, DD, EE, FF, GG, HH

TARGET
(B1) : AA
(B2) : BB
(B3) : CC
(B4) : DD
(B5) : EE
(B6) : FF
(B7) : GG
(B8) : HH

I made second part, but after second, i do not know how to make it...
=MID(A1,FIND(",",A1)+1,FIND(",",A1,FIND(",",A1)+1)-(FIND(",",A1)+1))

please help me to do..

 

[KP117]

Depending on just what the data can be like, that could easily fail.
Try it with this text in A1

AAAAAAAAAAA, BBBBBBBBBBB, CCCCCCCCCCC,DDDDDDDDDDD,EEEEEEEEEE,FFF,GGG

In this case, the formula could be change to

=TRIM(MID(SUBSTITUTE(A1,",",REPT(" ",1000)),1+1000*(ROW($A$1:$A$50)-1),1000))

But I agree with you, totally, that this could be failed, easily. Thank you very much for your valued feedback.

 

[Peter_SSs]

In this case, the formula could be change to ...

Apart from the possibility of an ever-increasing number of spaces to insert (& how would we know whether to insert 100 or 1,000 or 10,000 etc?), your approach has another fairly significant weak point: What happens if somebody subsequently inserts any new row(s) at the top of the worksheet?