Pammy

See the gnu's post which should get you straightened out.

But...........you should be getting #N/A returned, not #REF!


Gord Dibben MS Excel MVP

On Wed, 23 May 2007 12:04:01 -0700, Pammy
wrote:

I have an excel worksheet sent from our Payroll dept from another application
used for Payroll. The column with emp #'s has a ' in front of the
number('21333). I have tried to edit - find ' but it doesn't find it. I
cannot do a vlookup because of this, I keep getting a ref# error. Any idea
on how to get rid of the ' in front of the number?