Excel find() doesn't work?

[Huajie]

Hi:

I have one column of strings in an Excel 2003 workbook, and I would
like to find a substring in each cell of that column, so I used find()
function to do it.

If I write formula for each cell individually, then it will work. But
if I just write the fomular for the first cell, and then drag it to
cover the later cells in one column, then it will only return the
first cell's find results, even if if I click on each cell's function
formula and see they are all correct.

For example, I have one column at the A column, and I want to find the
"abc" in each cell of the A column and return the results in the B
column. If I input B1=FIND("abc",A1) and drag it along the column B,
and I can see B2's formula is =find("abc", A2), and B3's formula is
=find("abc", A3), I still got the below results.

A B
----------------------------
xyz #VALUE!
abc xyz #VALUE!
abc xyz #VALUE!

p.s., I had tried search() function too, but it didn't work either and
the results were similar.

Can anyone help me solve this problem?

Thanks.