I apologise. Let me try to illustrate:

File A data VLOOKUP value -- File B data RESULT
'abc123 abc123 #N/A

I would like to remove the apostrophe in the data in File A.

Thanks.

" wrote:

Not sure if this is why you want to remove the apostrophe, but if your
hidden apostrophe is in front of a zero and you need to display the
number with leading zeros but no apostrophes : To get 0123456 from
'123456 :

Column A Column B
'123456 =RIGHT("0000000"&A12,7)