Hello All,
This thing has stumped me.
I trying to separate a bullet point list from one cell into different columns using this formula:
=TRIM(LEFT(SUBSTITUTE(MID(D4,FIND("|",SUBSTITUTE(D4,"•","|",1))+1,LEN(D4)),"•",REPT(" ",LEN(D4))),LEN(D4)))
It works most of the time, but sometimes it...