Hi

Can someone help me with this issue.

How do i extract data from aaaaaa_bbbbbb_cccccccc__dddddd_eeeeeee.

The number of characters are not the same. I want to extract the characters of each "_ "

I only know how to extract the first string before "_ " =LEFT(A1;FIND("_";A1)-1)