Browse » Home
Saturday, December 24, 2011
How to Replace Text in Excel 2007
1. Open the Microsoft Excel 2007 spreadsheet that you want to replace text for. Click on any cell in the spreadsheet.
2. Click on the 'Home' tab and then click on the 'Find and Select' option from the 'Editing' group.
3. Click on the 'Replace' button. Enter the text that you want to find in the 'Find what' text box and then enter the text you want to replace that with into the 'Replace with' text box.
4. Click on the 'Options' button to define your search by selecting specific rows or columns, to search for case-sensitive data, or to match the entire cell contents.
5. Click on the 'Replace' option to replace text that is found or click on the 'Replace All' option to replace all of the text throughout your spreadsheet.