Thread: Sorting
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Sorting

=--MID(A1,4,4)


"tcidawn" wrote:

We use a custom formatted number ##-####-## I need to be able to sort by
the middle four digits for a report. Can someone help me please? I have
done it before, but I am having a brain freeze.

Thanks
Reply With QuoteReply With Quote