Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find and replace, within workbook | Excel Discussion (Misc queries) | |||
find replace format | Excel Discussion (Misc queries) | |||
Find & Replace in VB macro | Excel Discussion (Misc queries) | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
VB Find and Replace | Excel Worksheet Functions |