Separating mixed data into meaningful pieces

Hello all, My question is about converting the text into columns with the Excel. All i want is to convert the mixed text data in a column into meaningful data pieces with an elegant/smart move. I am...