Extract a List from an array of Concentated and normal values

[cheal2]

Hi I have the following list in column A:

A123
B213
C412 A314
D411
B615 E891
G349
A019 I532 H682 C333

I need to extract the extra values from the cells that have more than one value and put in to its own cell. Such as below. Order isn't of particular concern. This should be a formula solution. Rather not use a macro - but I'll understand if its the only option.

A123
B213
C412
A314
D411
B615
E891
G349
A019
I532
H682
C333

Thanks for the help!

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[cheal2]

So the data above was for demonstration purposes. Actuallity is the data was all numbers with a fixed length, but all formated as text. However some of the values would have multiple ID's as shown above.

Therefore, column A had the source data. Then in columns B-K I set up each cell to grab a fixed length of data from column A - so column B would grab the first bit of data, column C would grab the second, etc etc. At the same time I convereted these "text" numbers to values as I grabbed them.

Then I set up an index column in L and in column M I returned the largest value from the array B:K based on the corresponding index value in column L.

This gave me a list of all values sorted largest to smallest. Source data would not have duplicate values and had consistent size and type therefore this solution worked for my needs.