"text to columns" and mantain hyperlink

Copied list of E-mails that all wound up in the same cell.
Would like them to each be in thier own cell so I can sort.
Using “TEXT TO COLUMNS” works great, but the hyperlink is lost.

Any way to mantain the hyperlink and still move each to it’s own cell ?

Thanks, ⌡im