Thread: Looking for a formula that will convert IP address for sorting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Looking for a formula that will convert IP address for sorting
more examples


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"metelcom" wrote in message
...
I want a formula that will create an IP address that can be sorted properly

example:

Row A Row B
11.23.45.678 011.023.045.678

Reply With QuoteReply With Quote