i have hundreds of cells containing: (Example:#103 / 4 / 23) or (#105 / 3 /
17 ) ... how can I convert these cells to sort by the second number value;
the 3 or 4 in the example ... Much Thanks !!

If you don't need it all in one column and all of the numbers are the same
format, you could go to data then text to columns and have the delimitor be
/, then sort by the 2nd new column.

"MikeInPortland" wrote:

> i have hundreds of cells containing: (Example:#103 / 4 / 23) or (#105 / 3 /
> 17 ) ... how can I convert these cells to sort by the second number value;
> the 3 or 4 in the example ... Much Thanks !!

Hi Mike

You could create a helper column with the formula
=--(SUBSTITUTE(MID(A8,8,3),"/",""))
Use the helper column to sort by.

This will work provided the number between the two slashes does not
exceed 999

--
Regards

Roger Govier


"MikeInPortland" <(E-Mail Removed)> wrote in
message news:4CF25F6E-78C0-4140-9F71-(E-Mail Removed)...
>i have hundreds of cells containing: (Example:#103 / 4 / 23) or (#105 /
>3 /
> 17 ) ... how can I convert these cells to sort by the second number
> value;
> the 3 or 4 in the example ... Much Thanks !!