Re Find, make sure you select "Match entire cell contents".

--
Jim
"GE Johnny" <GE wrote in message
...
I am using DGET to retrieve inforamtion on a spreadsheet. My problem is
Excel
is seeing duplicate information when there is none. Excel is seeing
MGC-HDVM
and MGC-HDVMH as the same text. If I remove the dash then the problem goes
away. These are part numbers I am looking up and I would like to show them
as
they appear with the dashes. I have the same problem if I use the find
function. When I type in MGC-HDVM and click on find it also displays
MGC-HDVMH as if it were the same text.