Find and Replace
 

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

Find and Replace
 

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