Seperating values in a cell based on characters

[ZEBALL07]

I am trying to seperate multiple values in a cell based on rather or not they are BOLD. Is this possible without doing it manually (which is what I do now). :(

I attached 2 pictures showing the before and what it looks like after manually seperate the values from BOLD and not bold.

[#2]

You need VBA coding to do it.