Delete Left Character

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have exported from access to excel and am now trying to
do a vlookup on one of columns within the extraction. But
as you know the export places an ' infront of the number
that I am trying to use for the vlookup. What is an easy
way to get rid of the ' ?
Thanks for your help.
 
Select the column, then:

<Data> <TextToColumns> <Finish>
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have exported from access to excel and am now trying to
do a vlookup on one of columns within the extraction. But
as you know the export places an ' infront of the number
that I am trying to use for the vlookup. What is an easy
way to get rid of the ' ?
Thanks for your help.
 
Insert a helper column and type this formula (assuming you
(') values are in Column A:

=--A1

This will get rid of the ' for numbers...

=A1 will get rid of the ' for text...

Then copy> pastespecial.values
Cheers
Juan
 
Back
Top