Finding Text

[tileguy]

=MID(A1,FIND(",",A1&",")+2,MAX(0,FIND(",",A1&",,",FIND(",",A1&",")+1)-FIND(",",A1&",")-2))

Can the above formula be revised to find other pieces of text separtated by commas in a cell?

For example, if I have: aaa, bbb, ccc, ddd, eee in a cell and I need "aaa" in one cell and "ddd" in another cell, can it be done?

 

[Norie]

Can you stick to the original thread here.