Thread
:
Convert text string to IP address
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Rajesh Mehmi
external usenet poster
Posts: 26
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!
Reply With Quote
Rajesh Mehmi
View Public Profile
Find all posts by Rajesh Mehmi