Sort Data Out of One Cell

D

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

RagDyer

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

Post back with any questions.
 
D

dbizek

Yes they are all the same length. THANKS!

WORKS PERFECT!

Roger Govier said:
Hi

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

--
Regards

Roger Govier


dbizek said:
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)
Click to expand...
Click to expand...
 
D

dbizek

See the reply after yours. It worked perfect.

Thanks!

gDyer said:
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 said:
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)
Click to expand...
Click to expand...
 
M

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
 
Top