See the reply after yours. It worked perfect.

Thanks!

gDyer" wrote:

Check out TTC - Text To Columns - in the Help files.
That should be perfect for what you need.

Post back with any questions.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"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)