G Guest Jan 27, 2005 #1 How can I reformat IP addresses out of a text string so that I can use their values in my excel/vb functions. Thanks
How can I reformat IP addresses out of a text string so that I can use their values in my excel/vb functions. Thanks
C Chip Pearson Jan 27, 2005 #2 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
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
C Chip Pearson Jan 27, 2005 #3 Debug.Print Arr(Ndx) should be Debug.Print Arr(N) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Debug.Print Arr(Ndx) should be Debug.Print Arr(N) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
B Bob Phillips Jan 27, 2005 #4 Break each component down into separate cells with Data>Text to Columns and a separator of stop '.' -- HTH RP (remove nothere from the email address if mailing direct)
Break each component down into separate cells with Data>Text to Columns and a separator of stop '.' -- HTH RP (remove nothere from the email address if mailing direct)
