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.