text to columns
 

i am trying to text the data into two columns (delimited by space) but can
only display the names in a new column line but not the rest number. The data
are all in one cell but with a square box after the name. I guess it is the
Return key symbol. How I can remove it or text the data into two. I need to
seperate the name and the #. Thanks,