cell formats
 

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?

cell formats
 

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?

cell formats
 

Try to use the function VALUE in other column to retrieve the emp #. After,
you can use VLOOKUP

--

Rodrigo Ferreira


"Pammy" escreveu na mensagem
...
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?

cell formats
 

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?