Find and Replace

K

koba

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
 
L

L. Howard Kittle

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
 
Top