View Single Post
 
Old 04-01-2020, 01:10 PM
arkansawyer16 arkansawyer16 is offline Windows 10 Office 2019
Novice
 
Join Date: Apr 2020
Posts: 2
arkansawyer16 is on a distinguished road
Default Trying to change the last digit in a column of 10 digit entries

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
Reply With Quote