Sort Data Out of One Cell

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

[RagDyer]

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" <[email protected]> wrote in message
news:[email protected]...
> 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)

[Roger Govier]

Hi

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

--
Regards

Roger Govier


"dbizek" <[email protected]> wrote in message
news:[email protected]...
> 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)

[dbizek]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
>
>
>

[dbizek]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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)
>
>