![]() |
|
#1
|
|||
|
|||
|
I have a column of 10 digits and some of the end with 00 (double zero). I need to find each entry and change the last digit to a 5 (five) leaving the other 9 digits the same. I'm not sure how, in Find & Replace to just change the last digit. I used question marks for the first 8 characters and then the double zeros to find the entries but can't figure out what to enter for the Replace field?
any ideas Thanks |
|
|
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 |