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