![]() |
#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 |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |
![]() |
laucn | Excel Programming | 14 | 05-17-2015 12:12 PM |