| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple find mulitple replace
is there any way out where i can choose multiple find in same sheet/workbbok
to replace with multiple replacement.ur help is solicited. say **US$ spread across the sheet without any fixed cell location to be replaced with say word xyz at all those places *US$ similarly placed all around the sheet to be replaced with abc NON-US to be placed with mno, and so on. even vb code will help,i can place that code in my macro. rgds amit -- rgds |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Multiple find mulitple replace
Look at EDIT== REPLACE but be careful of the order of actions if you have
similar strings to replace. For example, replacing "*US$" will also replace "**US$" so you need to do the latter first. HTH "spaceage" wrote: is there any way out where i can choose multiple find in same sheet/workbbok to replace with multiple replacement.ur help is solicited. say **US$ spread across the sheet without any fixed cell location to be replaced with say word xyz at all those places *US$ similarly placed all around the sheet to be replaced with abc NON-US to be placed with mno, and so on. even vb code will help,i can place that code in my macro. rgds amit -- rgds |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find/Replace in multiple worksheets | Excel Discussion (Misc queries) | |||
| find replace in multiple sheets based on namebox | Excel Discussion (Misc queries) | |||
| Multiple Find and Replace in one function | Excel Worksheet Functions | |||
| Find duplicate entries within mulitple worksheets, then listing th | Excel Worksheet Functions | |||
| How can I do a find and replace for a cell that has multiple line. | Excel Discussion (Misc queries) | |||
Linear Mode
