Trying to remove a space before a number in a cell

Hi Folks

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

Any ideas?

The "space" is actually the non-breaking space character, with a code of 160 instead of the usual 32. This can be removed from all the cells in one operation using Find & Replace (CTRL-H). Highlight all the cells in the column, then CTRL-H, and:

Find What: Alt-0160

Replace With: leave empty

Then click on Replace All

where Alt-0160 mean to hold down the Alt key and type 0160 on the numeric keypad. Alternatively, you can copy that space from one of the affected cells.

Hope this helps.

Pete