Here's two ways that work...
1. Include this function in a module in the workbook with the data (or your
personal macro worlkbook)
then you can use it like any worksheet function, it will make a duplicate of
you data without quotes.
'=================================
Function LoseQuotes(InputString As String) As Variant
LoseQuotes = Replace(InputString, "'", "")
End Function
'=================================

Or you can put this in a module and run it on an area by selecting the range
and running the macro
'=================================
Sub EraseQuotes()
Dim xCell As Range
For Each xCell In Selection
xCell.Formula = Replace(xCell.Formula, "'", "")
Next xCell
End Sub
'=================================
hth

M


"BlackBayou" wrote in message
...
Downloaded list looks like this:

'Z1753
'Z2857
'Z11288 etc

I need to remove the quotes in order to lookup values from a list that
does
not have the quotes. Simple nextnextfinish does not work, neither does
find' or findspace