I have a column of unique ID numbers that are preceeded by an apostrophe and formatted as either text or as a general number. I am trying to match this data column with another column in a different tab in the same workbook. I am having trouble with the too tabs matching because one column of data has the ' and other column does not. How can I remove the ' without removing the leading 0's it works when I retype the data- only then does the column match the other column in my indexMatch function.

data:
'008901
'008902
'008903
'009901
'010901
'010902
'011901
'215236
'542165

All ID numbers are 6 digits. Text to column does not work because it removes the 0s. In the second column that I am trying to match the numbers with the ID numbers show the preceeding 0s but do not have the '

Column 2
111902
181908
061914
140904
187907
150901
028902
077902


thank you kindly! this may be wordy as it is my first post!