In the options select WHOLE

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mr. Low" wrote in message
...
Dear Sir,

I encounter some problem in using €œFind and Replace€� function.

I highlight A1: A7 and type in €œBTH100€� to search the listing.

When I click next for 6 times the cursor goes to A1, follow by A2, A3,A4
and
A5 and finally returns to A1.

In my opinion, €œBHT100€� only occur twice in the listing, the cursor should
only goes to cell A1 follow by A5 and finally return to A1 again.

It should not go to other cells whereby its first six characters are
BHT100
because all those references are diiferent from what I key to search at
the
menu.

A
1 BTH100
2 BTH1006
3 BTH10086
4 BTH100065
5 BTH100
6 BTH206
7 BTH408


May I know how to make this function to do the right thing?

Thanks

Low

--
A36B58K641