Remove Spaces between Numbers

I need a macro that can take out space/spaces if its in a number the catch is some of them need the space taken out in-between a letter and number (refer to the attached sample.)

Sample.xlsx

I do currently use a macro to split at the first space to move the Name from the number which ends up causing part of the number to be moved over to column B.

Please Login or Register  to view this content.

I'm working with scanned to Excel files that most of the time do not totally scan right. I have been able to get allot of the issues worked out thanks to this forum but today the scanned files decided to start to throw random spaces in that cause some of my other macros not do the intended goal.

Output from D1

Please Login or Register  to view this content.

works great thank you