Prev: Tracking Sheet
Next: Excel 2007 Recent Documents List
From: goonie on 23 Mar 2010 15:57
I have a row of data that has strings of numbers / characters. Is there a way
to sort of the charaters whether they are at the beginning or end?

Example:
P224
24P
26A
28376A
A20958

I would like to sort by the Charater - when it either at the begining of the
string or end.

Thanks,
Kelly
From: Gary Brown on 23 Mar 2010 16:42
You'll need a 'helper' column.
Let's assume your data is in Column A starting in cell A1.
In cell B1 put the following formula and then copy it down.
=IF(CODE(LEFT(A1,1))>CODE(RIGHT(A1,1)),LEFT(A1,1),RIGHT(A1,1))
Sort on Column B.

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"goonie" wrote:

> I have a row of data that has strings of numbers / characters. Is there a way
> to sort of the charaters whether they are at the beginning or end?
>
> Example:
> P224
> 24P
> 26A
> 28376A
> A20958
>
> I would like to sort by the Charater - when it either at the begining of the
> string or end.
>
> Thanks,
> Kelly
From: goonie on 23 Mar 2010 17:02
Worked Great - Thank You

"Gary Brown" wrote:

> You'll need a 'helper' column.
> Let's assume your data is in Column A starting in cell A1.
> In cell B1 put the following formula and then copy it down.
> =IF(CODE(LEFT(A1,1))>CODE(RIGHT(A1,1)),LEFT(A1,1),RIGHT(A1,1))
> Sort on Column B.
>
> --
> Hope this helps.
> If it does, please click the Yes button.
> Thanks in advance for your feedback.
> Gary Brown
>
>
>
> "goonie" wrote:
>
> > I have a row of data that has strings of numbers / characters. Is there a way
> > to sort of the charaters whether they are at the beginning or end?
> >
> > Example:
> > P224
> > 24P
> > 26A
> > 28376A
> > A20958
> >
> > I would like to sort by the Charater - when it either at the begining of the
> > string or end.
> >
> > Thanks,
> > Kelly
 | 
Pages: 1
Prev: Tracking Sheet
Next: Excel 2007 Recent Documents List