I am trying to compare two lists by social security
number. However, one list has an apostrophe in front of
the ss# so the vlookup doesn't work. how do i get rid of
the apostrophe and make the format the same as the other
ss#?

thank you