I’ve done this before to get individual email addresses out of a lookup containing multiple email addresses.
I had to do it in stages -
First, strip off the first one, with a combination of LEFT and FIND, into its own cell.
Then strip off everything to the right of the first one, with a combination of RIGHT and FIND, into its own cell.
Then repeat the process with the addresses stripped off of the right side of the original - strip off the first one into its own cell, then strip off everything to the right of it into its own cell… and so on.
I believe that for 4 values, you’ll need something like 7 fields in total.
I also had to pepper the formulas with plenty of conditional checks for values to prevent errors.