Multi Replacement

T

tornado

hello

i dont know if that the question is possible or not :confused:

example i have number 2 in many cells, and i want to replace it with
other number so i make find replace, but why can i do if i want to
replace number 2 with multi number for example 3 to 9, ..... firt "2"
with 3 second "2" with 4 , to ....... 9 and continue with that
operation to finish all cells contain "2", so can i do that in Excel,
and if not any program can do that
tnx anyway....
 
T

Tom Ogilvy

This can't be done on a single command with any built in feature. You will
either have to run multiple replacements or build a macro to do it (or do it
manually.
 
Top