Thread: Sort by placement value from left to right & adding trailing zeros for short
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dacromley@wyoming.com is offline
external usenet poster
  
Posts: 2
Default Sort by placement value from left to right & adding trailingzeros for short
How about:
=CONCATENATE(SUBSTITUTE(A1,"-","~"),LEFT("~~~~~~~~",8-LEN(A1)))
What a mess, uh?
Reply With QuoteReply With Quote