The Split function can split the IP address in to an array.


Dim S As String
Dim Arr As Variant
Dim N As Integer
S = 12.34.56.78
Arr = Split(S,".")
For N = LBound(Arr) To UBound(Arr)
Debug.Print Arr(Ndx)
Next N


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"shois" wrote in message
...
How can I reformat IP addresses out of a text string so that I
can use their
values in my excel/vb functions. Thanks