Getting Sum of Multi-Value Dropdown list with Reference list

I did find some success with replacing the comma with a line break Char(10) but it does not seem to function for the last column well. I seem to be pulling doubles on the 4th destination.

Destination 1
=IF(ISERROR(FIND(CHAR(10), Destination@row)), Destination@row, LEFT(Destination@row, FIND(CHAR(10), Destination@row) - 1))

Destination2
=IF(ISERROR(FIND(CHAR(10), Destination@row, 1)), "",
MID(Destination@row,
FIND(CHAR(10), Destination@row) + 1,
IFERROR(FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row) + 1) - FIND(CHAR(10), Destination@row) - 1,
LEN(Destination@row) - FIND(CHAR(10), Destination@row))
)
)

Destination3
=IF(ISERROR(FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row) + 1)), "",
MID(Destination@row,
FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row) + 1) + 1,
IFERROR(FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row) + 1) + 1) - FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row) + 1) - 1,
LEN(Destination@row) - FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row) + 1))
)
)

Destination4
=IF(ISERROR(FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row) + 1) + 1)), "",
MID(Destination@row,
FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row) + 1)) + 1,
IFERROR(FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row) + 1) + 1) + 1) - FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row) + 1)) - 1,
LEN(Destination@row) - FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row, FIND(CHAR(10), Destination@row) + 1)))
)
)