splitting up an IP address

R

Ron Rosenfeld

macro works perfect. Thank you!
Click to expand...

I'm glad it works for you. Thank you for the feedback.

I'm curious -- what is the purpose of splitting up the IP address like this?


--ron
 
R

RagDyer

FWIW,
You could use TTC and *still* retain the original data column, intact.

On the last page (window) of TTC, there's a *destination* box, in which you
can simply specify exactly where you wish the separation to begin.
The default is the column being separated.
Just change it to the next, or any other column's address.

--


Regards,

RD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

splitting up an IP address 3
VBA Multiple Line handling with Split() 1
Unable To Connect To Internet - IP Address Conflict 6
IP address location 2
Disable spreadsheet when copied to incorrect file path or differen ip address 4
Macro Assistance (Splitting into new workbook by value) 4
splitting up an IP address 3
LG 24MP48HQ-P 24 Inch IPS LED Monitor 0

Top