sorting of long Excellist with varios content.

[VickyHu]

Hi,

I have a very long excellist with all the content in column "A"
As the content is not always the same, but could be differenciated between text and figures, i would like to now, how I can separate those datasets, to get a list with every information sorted into different columns

An example is added attached.

I would be very lucky, if you could help me.
thanks a lot,
Vicky