i am trying to determine if a cell has a partial value in it, for example
cola colb
john smith 1
john brown 2
bob smith 3
carly simon 4
john clark 5
tom smith 6


processing column a, top to bottom,for 'smith' would return 10, or 'john'
would return 8.

any help would be appreciated.

btw, if column a is a currency field can you find the '$'. i tried the
search function on that kind of field and it doesnt think it is text so
struck out.

can you 'convert' a cell to text for comparison purposes without having to
go change the true underlying format?

thanks.

jim

microsoft.public.excel.worksheet.functions