In Search and Replace dialog box
click on Options and choose 'match entire cell contents'

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Jenn" wrote:

I created subtotals and am summing up based on Customer Name. I now want to
Find and Replace all of the Customer Names, but leave the Customer
Name_Total. Is it possible to exclude * Total, so that I can remove all but
these?

For example:
ABC Company 150,000 4/3/09 *I want ABC Company removed here
ABC Company 450,000 4/3/09 and here
ABC Company Total 650,000 but left here.

Or is there another option other than Find and Replace to do this?

Thanks,