View Single Post
 
Old 09-18-2023, 01:24 PM
ctviggen ctviggen is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Feb 2021
Posts: 54
ctviggen is on a distinguished road
Default Search/replace numbers so that XYY becomes ZYY

Hi All,


I'd like to do a search/replace so that XYY becomes ZYY. For instance, 100 becomes 200, 110 becomes 210, 120 becomes 220, etc. That is, only the first number is changed and the other two are left alone.


I've tried using wildcards for this, but it doesn't seem to work in the ways I used.



I've also looked here for useful tools, but I cannot find the correct tool:


Finding and replacing characters using wildcards


(This is where I got the wildcard idea, though.)



Any help is appreciated, thank you.
Reply With Quote