Thanks Tom, Bob and Jason,
That worked...

"Tom Ogilvy" wrote:

Bob's formula
=LEFT(MID(A1,FIND("-",A1)+1,99),FIND("-",MID(A1,FIND("-",A1)+1,99))-1)

would assume your data is in column A. So this would be placed in cell B1,
then copied down next to each entry in column A.

--
Regards,
Tom Ogilvy

"bagman" wrote in message
...
Hello Bob,

As I told Jason I am not very good with excel..I got your formula. But how
and where to I enter it get the column to sort in a new column.
Thanks


"bagman" wrote:

How do you sort a column of numbers with hyphens?
Example #####-###-####.
I want to sort by the 3 middle numbers
Thanks