Hi Koba,
Only way I can think of is to run a macro like this.
Sub ReplaceEm()
Cells.Replace What:="2", Replacement:="3"
Cells.Replace What:="4", Replacement:="3"
Cells.Replace What:="5", Replacement:="3"
Cells.Replace What:="6", Replacement:="3"
Cells.Replace What:="7", Replacement:="3"
Cells.Replace What:="8", Replacement:="3"
Cells.Replace What:="9", Replacement:="3"
End Sub
HTH
Regards,
Howard
"koba" wrote in message
...
Hi all
how do i find and replace multiple items, i know how to do one, for
example
find 2
replace with 3
But how do i
find 2,4,5,6,7,8,9
replace with 3
all in the one go!!!
thanks
andrew
--
koba
------------------------------------------------------------------------
koba's Profile:
http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=487793