View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove Harlan Grove is offline
external usenet poster
 
Posts: 733
Default Excel - replacing Text in workbooks

Frank wrote...
How do I find and replace text in multiple workbooks at once? I am
translating a budget that is compiled of multiple workbooks and wish
to have Excel cahnge one word in many workbooks.


You have to do this one workbook at a time. You could use a macro to
iterate through all these workbooks, changing this one word in each.