Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
how do i find edit, replace in excel 2007 | Excel Discussion (Misc queries) | |||
Find and replace in excel | Excel Discussion (Misc queries) | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
Excel Find and Replace | Excel Discussion (Misc queries) |