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 doesn't and I cannot figure out why.
For example,
I have two cells here and one works, the other doesn't. I have found that if I reduce the characters in the first cell by deleting the text in red, the formula works.
What is going on here? Is this a character limit issue?
<tbody>
</tbody>
Here is an online workbook with the example. https://1drv.ms/x/s!Avza4YgA-BnDjBwMZ6nL1YudMvzq
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 doesn't and I cannot figure out why.
For example,
I have two cells here and one works, the other doesn't. I have found that if I reduce the characters in the first cell by deleting the text in red, the formula works.
What is going on here? Is this a character limit issue?
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Here is an online workbook with the example. https://1drv.ms/x/s!Avza4YgA-BnDjBwMZ6nL1YudMvzq