Sort Data Out of One Cell

[dbizek]

I've been given a spread sheet that has the customer name and thier customer
number in the same cell. Is there a way that I can sort out the customer
number to another cell so that a sort can be done by custome number.

EXAMPLE:[ ACE HARDWARE 889425 ] (all in one cell)

[mikecookaxa]

Choose Data Tab
then "text to columns"
then "deliminited"
click next
then chose "space"
click finish

that will seperate each word into it's own column

then you should be able to do any type of sorting from there