Okay here is my data where month directory is \0412 in all cells I want to replace all with \0512.
So I do a find replace all to have it cycle through. When there is an error in 2003 excell keeps looking you can hold down escape and it will go through the whole thing ignoring the errors.
In excell 2010 it stops as soon as it finds missing data. With 3000 plus cells per sheet this would take me all day to restart the find replace every time data is missing for a day.
|