Thread: How do I extract a string from an IP address in Excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mardoh mardoh is offline
external usenet poster
  
Posts: 4
Default How do I extract a string from an IP address in Excel?
I'm trying to extract the first 3 numbers from an IP address e.g.
10.123.11.250 to show it as 10.123.11 Would anyone know of a formula for
this please?
Reply With QuoteReply With Quote