Hi Katy,
Yes, there is a way to do a Find & Replace where you can find any cell which contains a certain text string within the cell contents, and replace the WHOLE CELL with another text string. Here's how you can do it:
- Select the range of cells that you want to search and replace.
- Press Ctrl + H to open the Find and Replace dialog box.
- In the "Find what" field, enter the text string that you want to find (in your case, ).
- In the "Replace with" field, enter the text string that you want to replace the whole cell with (in your case, "2008-09").
- Click on the "Options" button to expand the dialog box.
- Check the "Match entire cell contents" box.
- Click on the "Replace All" button.
This should replace all cells that start with "01/06/2008" with "2008-09". The asterisk (*) in the "Find what" field is a wildcard character that tells Excel to find any text string that starts with "01/06/2008".