Just fix it a little.
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,"<li>","|"),"</li>","|"),"|",REPT(" ",LEN($A2))),(COLUMNS($A:A)*2-1)*LEN($A2)+1,LEN($A2)))
Just fix it a little.
=TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A2,"<li>","|"),"</li>","|"),"|",REPT(" ",LEN($A2))),(COLUMNS($A:A)*2-1)*LEN($A2)+1,LEN($A2)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks