View Single Post
  #7   Report Post  
Old February 26th 08, 01:24 PM posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
First recorded activity by ExcelBanter: Jun 2007
Posts: 806
Default Sorting Numbers with letter suffixes


If I understand the problem correctly Max was almost the

If there can be more than one letter suffix I suggest to use
RegExpReplace to separate numerical and text parts...