Thread: sort a range of numbers ignoring preceding letters
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
j0hnt52
 
Posts: n/a
Default sort a range of numbers ignoring preceding letters
I have a range of reference IDs that are in the format:
AAA ###.### (eg ABC 123.456)
I wish to sort the range based only on the numbers in the ID (ignore any
text preceding the numbers).
I can use "text to columns" and then sort, but I was hoping there was an
easier way.
Reply With QuoteReply With Quote