G
Guest
I have someone who's Replace command replaces everything in one pass. With
mine however I have to repeat the process. This is Excel 2003
An example is lets say you want to replace all occurrences of two spaces
with one. The first time the Replace command is run it only makes one pass
removing only the first found two spaces in each cell. I have to run the
command several times to replace all occurrences. But the other person only
has to run it once.
Is there a setting somewhere? How does yours work?
Thanks
mine however I have to repeat the process. This is Excel 2003
An example is lets say you want to replace all occurrences of two spaces
with one. The first time the Replace command is run it only makes one pass
removing only the first found two spaces in each cell. I have to run the
command several times to replace all occurrences. But the other person only
has to run it once.
Is there a setting somewhere? How does yours work?
Thanks