Replacing numbers using excel macros

I have a spreadsheet which contains various type of data including IP addresses. I need to create a macro that will go though each cell and if finds an ip address to remove it or change it to a different character. The ip addresses are in between text within the cells.
The macro would need to go through the text in a cell and if it picks up "10." then find the end of the string and remove/rename.

Has anyone done this before? I'm new at creating macros and have tried to create it by using code on the web with no joy.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!