This was my first complex formula in Excel: =LEFT (A1, LEN(FIND("[",A1)-1) & CHAR(10) & =MID(A1, FIND(",",A1)+2, LEN(A1) - LEN(MID(A1, FIND("[",A1,FIND(",",A1))-1, LEN(A1))) - FIND(",",A1) - 1) & CHAR
Markdown supported · ⌘↵ to post
No responses yet.