View Single Post
  #1   Report Post  
EK
 
Posts: n/a
Default Vlookup data discrepancy

How do I remove the hidden apostrophy in a cell (see e.g.)? I have tried
Find/Replace, changed the Alignment and formatted the cell but failed.

e.g.

'alphanumericdata