Multi Replacement
 

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....


--
tornado
------------------------------------------------------------------------
tornado's Profile: http://www.excelforum.com/member.php...o&userid=25082
View this thread: http://www.excelforum.com/showthread...hreadid=385968

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.

--
Regards,
Tom Ogilvy

"tornado" wrote in
message ...

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....


--
tornado
------------------------------------------------------------------------
tornado's Profile:
http://www.excelforum.com/member.php...o&userid=25082
View this thread: http://www.excelforum.com/showthread...hreadid=385968