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)