FIND is not "finding" a number in a column which contains the
If the numbers are contained with other text/numbers in a cell you would not
select "entire cell contents".
e.g 12345 in a cell
Look for 234
If you have "entire cell contents" checked Find would not find 234
What does your data consist of? Spaces can be hard to see.
In an adjacent column enter =LEN(cellref) and copy down.
Is the length returned the same as your data?
Show us an example of your data.
Gord
On Wed, 7 Dec 2005 12:55:02 -0800, fdp wrote:
I do not have the box checked for search entire.... Do you think this is why
I am having problems? There does not appear to be any funny characters or
spaces.
Regards
"Gord Dibben" wrote:
Are you searching for entire cell contents or part of cell?
Do you have any extraneous spaces if searching by whole cell?
Gord Dibben Excel MVP
On Wed, 7 Dec 2005 09:56:03 -0800, fdp wrote:
I am having difficulties with the FIND wizard not finding a number that is
conatined in the column I am searching in.
|