Select the column:

Data Text to Columns.. Next Finish
--
Gary''s Student - gsnu200723


"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?