Find and Replace in an Entire Folder of Excel Workbooks Using Easy-XL
You have to change 400 workbooks for to prepare for next year's annual budget process. This truly GLOBAL find and replace will help.
By Bill Jelen on Tue, 08/31/10 - 8:57am.Say that you have hundreds of similar Excel workbooks in a folder and you need to globally change "2009 Budget" to "2010 Budget" in all of the workbooks. This will be a long tedious process for someone.
The Easy-XL program makes this task a breeze. Choose the folder, specify if subfolders should be used. You can specify if the search should include text, numbers, dates, or formulas. The program can ask you to confirm each replacement or simply attack the entire folder.
Easy-XL is free to try. Even after the trial expires, the Global Search and Replace, as well as four navigators and several new Excel functions (FiscalYear being my favorite) will remain unlocked forever.
Download the software from Easy-XL.com.
- About Author Expert: Excel 2010
Bill Jelen is the host of MrExcel.com and the author of 31 books about Microsoft Excel. Before founding MrExcel.com in 1998, he spent 12 years in the trenches in the accounting, finance, and operations departments, honing his power Excel skills. The MrExcel.com website answers 30,000 Excel questions a year, for free, for readers around the world. Jelen hails from Akron, Ohio.
Jelen's book Microsoft Excel 2010 In Depth has been selected as the August, 2010, book giveaway on Microsoft Subnet.
Jelen's book Using Microsoft Excel 2010 has been selected as the August, 2010, book giveaway on Microsoft Subnet.
Read a free chapter excerpt hosted by Microsoft Subnet.
Enter this month's book giveaways from Microsoft Subnet, Cisco Subnet and Open Source Subnet.
Most Discussed Posts
-
Network World, Inc
The Connected Enterprise