Hi

Is the Customer number always 6 digits?
If so then
=RIGHT(TRIM(A1),6)

--
Regards

Roger Govier


"dbizek" wrote in message
...
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)