I have a list of numbers and i need to do a lookup into another sheet.
The lookup is working for the most part except for those numbers in the sheet I am looking up into that seem to have a space before them.
I tried the TRIM function but it does not work.
Maybe it is due the format of the numbers or because it looks like they were pasted in from elsewhere. The format of the cell category is General.
I have attached the file