View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default delete certain text in a workbook

Duh. That is remarkably simple and I'm embarrassed I overlooked it.

Thanks.

Dave
--
Brevity is the soul of wit.


"JMay" wrote:

In 2003 (not sure befoe) you can use the Edit, Find and replace all option
Check the options button and from the Within: dropdown select "Workbook"

"Dave F" wrote:

How would I create a macro to search through a workbook and delete all text
strings that are either "Created by 10-K Wizard." or
"http://www.10kwizard.com/" ?

The strings would be replaced by "" (i.e., nothing.)

Thanks.

Dave
--
Brevity is the soul of wit.