Maybe the others will give a better formula that will search values in a range that has "00" at the end of the string then replace the last 0 to 5. The simplistic formula above will apply to all strings without regard to the value of the last 2 digits.
|