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

M

MikeInPortland

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

~L

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.
 
R

Roger Govier

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
 
Top