Hi all, I'm hoping someone can offer some support here on a lot of cells on a sheet that I need to alter the formula for.
Example is in Cell A1 I haveso what I want is a code that will search and replace the numerical part of the data and change it to that number plus 300 so it would change toFormula:Please Login or Register to view this content.I am needing to do this for a lot of cells, and the layout means that dragging etc doesn't work and manual entry is going to take me a long time to do. But all cells need to have the 300 cells added to them.Formula:Please Login or Register to view this content.
Thanks in advance if anyone can help.
John
Bookmarks