I am trying to remove spaces fro a list of UPC codes and =trim does not work. I have also tried to replace the space and whn I do excell removes the leading zero on skus that have them and gives me 6.5407E+11 on the first sample sku below and 26715204991 on the second sku below (missing leading zero now)

Here is a sample two skus:
6 56407 03125 5
0 26715 20499 1

How can I do this correctly?

Happy Thanksgiving