Hi - Welcome to the board
So the data is basically entered the way you have it? the problem is that there is nothing to tell excel what to keep and what to trim.
How many text strings would there be in the results wanted. You have 6, but one is a name so could there be any number of those or just a few?