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

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

Debug.Print Arr(Ndx)
should be
Debug.Print Arr(N)


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


"Chip Pearson" wrote in message
...
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

Break each component down into separate cells with DataText to Columns and
a separator of stop '.'

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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