Find & Replace in Excel 2007
I am using Excel 2007. I have a spreadsheet with numbers (values) and text.
When I use the Find and Replace feature to fing a specific value in my spreadsheet the find feature is not finding it. I also tried finding text and I am having the same problem. Any idea if there is a bug in that feature in the 2007 version or am I doing something wrong. If anyone wishes I can email the specific spreadsheet and you try the find & Replace feature and let me know if it works but you must use the 2007 of Excel version as that is what I am using. |
Find & Replace in Excel 2007
Hi,
Must be more to this problem, the feature works fine on my machine. -- Thanks, Shane Devenshire "RM" wrote: I am using Excel 2007. I have a spreadsheet with numbers (values) and text. When I use the Find and Replace feature to fing a specific value in my spreadsheet the find feature is not finding it. I also tried finding text and I am having the same problem. Any idea if there is a bug in that feature in the 2007 version or am I doing something wrong. If anyone wishes I can email the specific spreadsheet and you try the find & Replace feature and let me know if it works but you must use the 2007 of Excel version as that is what I am using. |
Find & Replace in Excel 2007
I doubt it's a bug.
You just don't the text or value as you think you have. Extra spaces will cause a no find if you have "match entire cell contents" checked. Gord Dibben MS Excel MVP On Wed, 2 Jul 2008 11:50:03 -0700, RM wrote: I am using Excel 2007. I have a spreadsheet with numbers (values) and text. When I use the Find and Replace feature to fing a specific value in my spreadsheet the find feature is not finding it. I also tried finding text and I am having the same problem. Any idea if there is a bug in that feature in the 2007 version or am I doing something wrong. If anyone wishes I can email the specific spreadsheet and you try the find & Replace feature and let me know if it works but you must use the 2007 of Excel version as that is what I am using. |
Find & Replace in Excel 2007
You may want to share what you're seaching for, too.
It could be a wildcard problem. Use ~* to search for * ~? to search for ? ~~ to search for ~ RM wrote: I am using Excel 2007. I have a spreadsheet with numbers (values) and text. When I use the Find and Replace feature to fing a specific value in my spreadsheet the find feature is not finding it. I also tried finding text and I am having the same problem. Any idea if there is a bug in that feature in the 2007 version or am I doing something wrong. If anyone wishes I can email the specific spreadsheet and you try the find & Replace feature and let me know if it works but you must use the 2007 of Excel version as that is what I am using. -- Dave Peterson |
All times are GMT +1. The time now is 12:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com