X10A
12-18-2009, 02:34 AM
Hi,
The title may be a bit confusing but I have no idea how to better phrase it. What I am looking for is to replace all characters from "c to g" with the number 9.
e.g:
cat > 9at
Cat > Cat
egg > 999
Egg > E99
The only way I know is to use find and replace function. Is there a vba function something like this?
Replace lowercase [c-g] with "9"
I know Excel does not interpret human language, but I do not know how to write the code in VBA language.
Thanks for any help here.
The title may be a bit confusing but I have no idea how to better phrase it. What I am looking for is to replace all characters from "c to g" with the number 9.
e.g:
cat > 9at
Cat > Cat
egg > 999
Egg > E99
The only way I know is to use find and replace function. Is there a vba function something like this?
Replace lowercase [c-g] with "9"
I know Excel does not interpret human language, but I do not know how to write the code in VBA language.
Thanks for any help here.