Tricky formatting problem

[hellfire45]

got some weird formatting issue here. So This is not a trim issue. Trim does not take care of this. Any ideas? we are just trying to do simple Vlookup here but writing a formula to fix the spaces and making the numbers the same is proving to be a challenge. Thanks!

 

[Vogateer]

Is it all formatted as text? Could you paste some sample data and formulas in here instead of a screenshot so we can use that same data for testing?

 

[dreid1011]

Have you tried CLEAN() ?

 

[hellfire45]

Have you tried CLEAN() ?

clean fixed it. Can you please explain the difference between CLEAN and TRIM? Thank you!

 

[dreid1011]

TRIM targets spaces, while CLEAN targets nonprinting characters.

 

[Bugman1400]

Try the FORMAT function. Search for its use and syntax in Microsoft support webpages.