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

Hello,

If I understand the problem correctly Max was almost the
=IF(A1="","",IF(ISNUMBER(A1),A1,--LEFT(A1)+CODE(LEFT(A1))/10^10))

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

Regards,
Bernd