View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
~L ~L is offline
external usenet poster
 
Posts: 177
Default 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 !!