Thread: How do I sort alpha neumeric fields that have an alpha suffix?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default How do I sort alpha neumeric fields that have an alpha suffix?
Have you tried sorting? I get 114 first then 114 with the a,b,c, etc in
order. What do you need?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Bob Sparks" <Bob wrote in message
...
How do I sort numbers with alpha suffix, e.g. 114, 114A, 114B, etc?


Reply With QuoteReply With Quote