View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rajesh Mehmi Rajesh Mehmi is offline
external usenet poster
 
Posts: 26
Default Convert text string to IP address

Hi

Try the formula below, If your data is in A1
=LEFT(A1,3) &"."& MID(A1,4,3 ) &"."& MID(A1,7,3) &"."& RIGHT(A1,3)


--
Best regards
Rajesh Mehmi



"Mike" wrote in message
...
I've got a bunch of text strings similar to this one: 064190119066. Is
there
a way to convert this into an IP address in Excel?

Thanks!