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

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>