View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
spaceage spaceage is offline
external usenet poster
 
Posts: 18
Default 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