View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Clem Clem is offline
external usenet poster
 
Posts: 18
Default GETTING RID OF LEADING HASH MARKS

While attempting to use VLOOKUP THE LOOKUP VALUE IS 12345 the column that
has the list of values to be looked at has '12345 so it is not recognized
and I get NA. The table I am working with has the ' attached to all of the
entries in that column. Is there any way I can get rid of the hash mark so
that my lookup will recognize the vale?