Sort Data Out of One Cell
 

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)

Sort Data Out of One Cell
 

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)

Sort Data Out of One Cell
 

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)

Sort Data Out of One Cell
 

Yes they are all the same length. THANKS!

WORKS PERFECT!

"Roger Govier" wrote:

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)

Sort Data Out of One Cell
 

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)

Sort Data Out of One Cell
 

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


--
mikecookaxa
------------------------------------------------------------------------
mikecookaxa's Profile: http://www.excelforum.com/member.php...o&userid=27926
View this thread: http://www.excelforum.com/showthread...hreadid=500291