Find and Replace #16

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?action=getinfo&userid=28639
View this thread: http://www.excelforum.com/showthread.php?threadid=487793

0
11/23/2005 9:52:05 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
436 Views

Similar Articles

[PageSpeed] 31

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" <koba.1yyz9m_1132782901.4713@excelforum-nospam.com> wrote in message 
news:koba.1yyz9m_1132782901.4713@excelforum-nospam.com...
>
> 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?action=getinfo&userid=28639
> View this thread: http://www.excelforum.com/showthread.php?threadid=487793
> 


0
lhkittle (223)
11/23/2005 10:19:15 PM
Reply:

Similar Artilces: