W
Woodman
I want to replace the last 2 digits of a series of cells that contain an 8
digit number and other text. The number is 18081800 and I want to make the
last 2 digits 01 instead of 00. When I use wildcards, it replaces the whole
number with the wildcards as well as 01. What am I doing wrong and can you
give me an example of the right wat to do this. Here is what I did:
Find what: 180*00
Replace with: 180*01
It replaces 18081800 with 180*01. Why?
digit number and other text. The number is 18081800 and I want to make the
last 2 digits 01 instead of 00. When I use wildcards, it replaces the whole
number with the wildcards as well as 01. What am I doing wrong and can you
give me an example of the right wat to do this. Here is what I did:
Find what: 180*00
Replace with: 180*01
It replaces 18081800 with 180*01. Why?