How do i sort values like: #103 / 4 / 23, need to sort by 2nd #
 

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 !!

How do i sort values like: #103 / 4 / 23, need to sort by 2nd #
 

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 !!

How do i sort values like: #103 / 4 / 23, need to sort by 2nd #
 

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" wrote in
message ...
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 !!