#1
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
wildcard search and add (not replace) sequential numbers in front | equalizer88 | Word VBA | 4 | 05-07-2016 08:04 PM |
Search a cell that contains words and numbers and convert the numbers to metric | Carchee | Excel Programming | 36 | 10-08-2014 03:16 PM |
search and replace a field containing text and numbers | H28Sailor | Word | 6 | 09-11-2014 01:00 AM |
search and replace | dirkoo | Word VBA | 2 | 08-14-2013 11:25 AM |
Search and Replace - Clear Search box | JostClan | Word | 1 | 05-04-2010 08:46 PM |