I am looking to remove the ' before the content of a cell in order to do a VLookup, whowever when there are no letters it is turning the value into a number and the vlookup is retrieving inaccurate values. Any idea?

pre - '02364W105
post - 02364W105

pre - '151290889
post - 151290889 (this becomes 1.51E+08)