|
|
#4
04-01-2020, 03:35 PM
|
||||
|
||||
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.
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| long digit error | Midasbelize | Excel | 1 | 05-16-2017 10:14 AM |
| Changing Distance Between a Digit and it's Subscript | mohsen.amiri | Word | 2 | 01-22-2017 12:59 AM |
| Selecting a digit from a code | Warren99 | Excel | 2 | 05-29-2016 04:08 AM |
| Regex/wildcard search for dates with 2-digit and 4-digit years | Marrick13 | Word VBA | 2 | 01-29-2016 07:04 AM |
 A challenging digit by digit manipulation, rotate the digit in range of 0 to 9
|
laucn | Excel Programming | 14 | 05-17-2015 12:12 PM |
Windows 7 32bit 
Office 2013
Threaded Mode