Thread: Sort by number only in cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Liliana[_4_] Liliana[_4_] is offline
external usenet poster
  
Posts: 39
Default Sort by number only in cell
Microsoft has a ready-rolled array formula:

http://office.microsoft.com/en-gb/ex...549011033.aspx

Don't forget Ctrl-Shift-Enter


?B?c2VyZW5kaXBpdHkyNTg=?=
wrote in :

3
A100C
A100D
AB205
B4
53DE

Reply With QuoteReply With Quote