Hello.

I have an excel file, which is used for accounting of some equipment.
We have a barcode scanner, which scans s/n's and enters them in excel.
Those serial numbers are of different types: 001AC310B838, 3105189007, 00532505231, 20078700024F8A030413, HCC8CASOJIC0FCNSN0016105.

We have problem with serial numbers such as 00532505231.
Cell that scaner is entering those serials into is set to Text format.

For some reason when scanning this type of serials it adds extra space after last character, and because of that some formulas do not work correctly.

If I try to Find and Replace space with nothing - it does remove space, but also removes first two 0.
So, after scanning I have cell with value "00532505231 ", I replace space with nothing and I get "532505231". Why is this happening?
It still is a Text format field after replace.

Ideally it would be perfect to find the solution for scanner (or is it excel) to not add that extra space at the end, and also to fix all those already scanned serials by removing extra space.

Any ideas?